Page 1 of 1

How to find which USER_ID has updated the DB2 table??

PostPosted: Mon Jun 24, 2013 6:53 pm
by vkumarg3
Hi all,

Some one has updated my DB2 table. Is there anyway to find which ID has performed that updation ??
I am little aware of system tables. So please help

Thanks in advance.

Re: How to find which USER_ID has updated the DB2 table??

PostPosted: Mon Jun 24, 2013 7:22 pm
by dick scherrer
Hello,

Ask your dba if there is some log analysis process available.

Re: How to find which USER_ID has updated the DB2 table??

PostPosted: Mon Jun 24, 2013 8:45 pm
by Pandora-Box
May be you could also try to add Triggers to your table on DELETE and having so populate the end table with "USER" so then you could catch the culprit ;)