db2 audit user activity

[paul]

Hi,
I must audit all user activities on a database and i don't know how to
proceed
I must keep the logs 3 years, and i must be able to know who changed one
record and the old/new values.

The options i have :
db2audit ?
event monitor statements ... ?

these two generates a lot of overhead i think

or can i use a logminer ? if yes i just need to keep the archive logs and
"logmine" them ?

Thx for any help

Paul

[dotyet]

there is a third party app called "IPLOCKS" which mines the logs....
if you are slightly enthusiastic, you can write your own set of perl/
shell scripts to parse the log files. mind you though that your
server's disk IO will increase many folds in all circumstances.

regards,
dotyet

On Jun 13, 4:35 am, "paul" <[e-mail]:

Hi,
I must audit all user activities on a database and i don't know how to
proceed
I must keep the logs 3 years, and i must be able to know who changed one
record and the old/new values.

The options i have :
db2audit ?
event monitor statements ... ?

these two generates a lot of overhead i think

or can i use a logminer ? if yes i just need to keep the archive logs and
"logmine" them ?

Thx for any help

Paul