Log mining

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rana - 22 Dec 2005 22:51 GMT

Is there a way to read the (archived) logical log files to see the sql
statemets that got executed. The classic example is when 'some joe'
programmer ran a bad query, trashed the database and then come back and
blame the dbas for ' you did it all', how can we defend ourselves? I
know a very round about way using db2 recover expert, is that the only
way ?

Reply to this Message

theman - 28 Dec 2005 16:22 GMT

You could write C/C++ code using the admin API to mine the log.
Take a look at db2ReadLog and the log record structures in the docs.

You could also look at the db2 audit features.

HTH.
theman.

> Is there a way to read the (archived) logical log files to see the sql
> statemets that got executed. The classic example is when 'some joe'
> programmer ran a bad query, trashed the database and then come back and
> blame the dbas for ' you did it all', how can we defend ourselves? I
> know a very round about way using db2 recover expert, is that the only
> way ?

Reply to this Message