SEO

permalink · #1 (**permalink**) 02-27-2008, 12:46 PM

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

permalink · #2 (**permalink**) 02-27-2008, 12:46 PM

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" <nom...@nomail.com> wrote:
> 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

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

SEO

db2 audit user activity