DB2 UDB Detective - Ace Ventura

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rAinDeEr - 24 Mar 2006 04:25 GMT

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

Reply to this Message

Knut Stolze - 24 Mar 2006 10:44 GMT

> 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.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Serge Rielau - 24 Mar 2006 12:41 GMT

> Hi,
>
[quoted text clipped - 8 lines]
> 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

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message