Joined: 30 Jan 2012
Firstly, my apologies if this question was already posted. I searched for a few combinations in the forum but didn't find the appropriate one so I am guessing I am the first one to ask this, but incase if you have already discussed on this then please redirect me.
I have a requirement where I have to run a logscan job on few tables and collect the data on few of the columns, also I have to collect the plan name/ correlation id for that unit of work, meaning I have to find what program updated/deleted/inserted that row.
I tried to use the following option
But this is giving me the unit of recovery id details, database name, table space name and table name but is not returning the plan name or correlation id.
I did a little research on SYSIBM tables which use the plane name columns or correlation id and I found that SYSIBM.DSN_PGROUP_TABLE has near to what I need but unfortunately I have no access to that table to see the actual content.
Could you please help me if you know any solution on this?
Thanks a many for your help!!