Identify the user who deleted a record from a table in IBM DB2?

RDBMS from IBM.
Previous topicNext topic

Topic Author
Kishor Sonawane
Registered Member
Posts: 23
Joined: Thu Nov 21, 2013 3:25 pm

Identify the user who deleted a record from a table in IBM DB2?

Post by Kishor Sonawane » Sat Feb 11, 2017 11:40 pm

Hi - Can we identify the user who deleted a record from a table in IBM DB2? What is command to get it or do we need to do some setup before we can get this information. Please advise.



User avatar

Anuj Dhawan
Founder
Posts: 2624
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Zodiac: Sagittarius

Re: Identify the user who deleted a record from a table in IBM DB2?

Post by Anuj Dhawan » Mon Feb 13, 2017 11:30 am

If you've audit facility turned ON beforehand prior to record being deleted, you might capture it. The audit trace enables you to trace different events or categories of events by authorization IDs, object ownership, and so on. And when you start the trace, you choose the events to audit by specifying one or more audit classes. Description of them can be found here:

https://www.ibm.com/support/knowledgece ... trace.html

OTOH, if you some tools like CA Log Analyzer or Platinum Tool - they might also allow you to look for such an information but I can not confirm for sure.


Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.


Topic Author
Kishor Sonawane
Registered Member
Posts: 23
Joined: Thu Nov 21, 2013 3:25 pm

Re: Identify the user who deleted a record from a table in IBM DB2?

Post by Kishor Sonawane » Mon Feb 13, 2017 2:34 pm

Thanks Anuj.

Can we get some information from DB2 logs too?



User avatar

Anuj Dhawan
Founder
Posts: 2624
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Zodiac: Sagittarius

Re: Identify the user who deleted a record from a table in IBM DB2?

Post by Anuj Dhawan » Wed Feb 15, 2017 11:26 am

Logs would not really give information on "who did it" but "what happened" can be answered mostly, AFAIK.


Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.


Topic Author
Kishor Sonawane
Registered Member
Posts: 23
Joined: Thu Nov 21, 2013 3:25 pm

Re: Identify the user who deleted a record from a table in IBM DB2?

Post by Kishor Sonawane » Wed Feb 15, 2017 1:37 pm

Thanks Anuj.



User avatar

Anuj Dhawan
Founder
Posts: 2624
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Zodiac: Sagittarius

Re: Identify the user who deleted a record from a table in IBM DB2?

Post by Anuj Dhawan » Thu Feb 16, 2017 11:32 am

You're welcome.


Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.

Previous topicNext topic

Return to “IBM DB2.”