By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

DB2 UDB Detective - Ace Ventura

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.