Sample Header Ad - 728x90

DB2 - Is there a way to get the list of tables a particular transaction has affected?

0 votes
0 answers
141 views
We have a scenario where we would like to see if we could get hold of a list of tables affected by a given transaction. We use attunity to listen on the transaction log, but what I get from attunity is the transaction ID associated to a given event (a row change for a single table), not how many other tables that transaction has affected. Consider the below update events -
UPDATE DEPARTMENTS SET (DEPT_NAME) = ('ChangedName3') WHERE DEPT_NO = 'd010';

UPDATE EMPLOYEES SET (FIRST_NME) = ('Georgi2') WHERE EMP_NO = '10001';

UPDATE DEPT_EMP SET (FROM_DTE) = ('1986-06-26') WHERE EMP_NO = '10001' AND DEPT_NO = 'd005';

UPDATE SALARIES SET (SALARY) = ('60111') WHERE EMP_NO = '10001' AND FROM_DTE = '1986-06-26';

UPDATE TITLES SET (TITLE) = ('Sr. Engineer') WHERE EMP_NO = '10001' AND FROM_DTE = '1986-06-26';

COMMIT;
This generates 5 events each having the transaction id - 00000000C420BC4E86DD010000000100 (I used a sample from attunity output). Can I get something like - 00000000C420BC4E86DD010000000100, {EMPLOYEES, DEPARTMENTS, DEPT_EMP, SALARIES, TITLES} on each of the 5 events? Or query DB2 to find this information?
Asked by Nilay Sundarkar (101 rep)
Mar 10, 2020, 06:07 PM
Last activity: Mar 10, 2020, 08:43 PM