467,153 Members | 934 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,153 developers. It's quick & easy.

DB2 UDB Detective - Ace Ventura

Hi,

How to find out what all changes have been made to the Database and
which user has done the change.?

Is there any location where these kind of information is stored?

I have DB2 UDB v8.2 installed in RHEL and around 30 users who access
the tables.
A number of times users update the tables with the wrong information
and I need to find out whose doing the wrong updates..and what changes
they have made and the number of rows affected in the process..

~ Me

Mar 24 '06 #1
  • viewed: 1130
Share:
2 Replies
rAinDeEr wrote:
Hi,

How to find out what all changes have been made to the Database and
which user has done the change.?


Have a look at the db2audit facilities. Maybe this will help you along.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Mar 24 '06 #2
rAinDeEr wrote:
Hi,

How to find out what all changes have been made to the Database and
which user has done the change.?

Is there any location where these kind of information is stored?

I have DB2 UDB v8.2 installed in RHEL and around 30 users who access
the tables.
A number of times users update the tables with the wrong information
and I need to find out whose doing the wrong updates..and what changes
they have made and the number of rows affected in the process..

If you want auditing on the row level you will need to add audit tables
and maintain them using triggers.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Mar 24 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Frank Rizzo | last post: by
66 posts views Thread by mensanator@aol.com | last post: by
reply views Thread by Lou Evart | last post: by
3 posts views Thread by fjm | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.