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



IBM's flagship relational database management system

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

Postby vkumarg3 » Mon Jun 24, 2013 6:53 pm

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.
vkumarg3
 
Posts: 29
Joined: Fri Jan 06, 2012 9:29 am
Has thanked: 10 times
Been thanked: 0 time

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

Postby dick scherrer » Mon Jun 24, 2013 7:22 pm

Hello,

Ask your dba if there is some log analysis process available.
Hope this helps,
d.sch.

These users thanked the author dick scherrer for the post:
vkumarg3 (Thu Aug 01, 2013 4:45 pm)
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

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

Postby Pandora-Box » Mon Jun 24, 2013 8:45 pm

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 ;)

These users thanked the author Pandora-Box for the post:
vkumarg3 (Thu Aug 01, 2013 4:45 pm)
User avatar
Pandora-Box
 
Posts: 65
Joined: Fri Feb 10, 2012 8:30 pm
Location: Mars
Has thanked: 3 times
Been thanked: 6 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post