Hi,

i am searching a logfile where all SQL transactions are stored. To be more specific, i am working on a strange java application written by some other guys and i want to see what kind of SQLs are arriving at the DB2. Where do i have to look for these kind of informations? I allready checked files in SQLLOGDIR but this stuff was not readable.

Thanks.

marc

You can use an event monitor ...

or

For dynamic sql, use dynamic sql snapshot (get snapshot for dynamic sql on <dbname>)

For static sql, you can look at the syscat.statements view

HTH

Sathyaram

Thanks.

(man, this guy knows a lot about DB2 ;-))