SEO

#1 (**permalink**) 02-27-2008, 06:30 AM

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

#2 (**permalink**) 02-27-2008, 06:30 AM

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

#3 (**permalink**) 02-27-2008, 06:30 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

DB2 UDB Detective - Ace Ventura