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 ?

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.


Rana wrote:
> 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 ?