Identify the user who deleted a record from a table in IBM DB2?
-
- Registered Member
- Posts: 26
- Joined: Thu Nov 21, 2013 3:25 pm
Identify the user who deleted a record from a table in IBM DB2?
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.
- Anuj Dhawan
- Founder
- Posts: 2812
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: Identify the user who deleted a record from a table in IBM DB2?
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.
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.
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.
-
- Registered Member
- Posts: 26
- Joined: Thu Nov 21, 2013 3:25 pm
Re: Identify the user who deleted a record from a table in IBM DB2?
Thanks Anuj.
Can we get some information from DB2 logs too?
Can we get some information from DB2 logs too?
- Anuj Dhawan
- Founder
- Posts: 2812
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: Identify the user who deleted a record from a table in IBM DB2?
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.
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.
-
- Registered Member
- Posts: 26
- Joined: Thu Nov 21, 2013 3:25 pm
- Anuj Dhawan
- Founder
- Posts: 2812
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: Identify the user who deleted a record from a table in IBM DB2?
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.
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.
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute