Does DB2 have a way to dump all incoming SQL statements on all connections to a file, or a console? I would like to see what SQL statements are being submitted by users.

Thanks,
-Aakash

Event Monitor is the closest thing you can get ...

Informtaion at
http://www.db2click.com/tip_month.htm
under event monitoring and event monitoring - using pipes

HTH

Sathyaram

I would look at the Dynamic SQL snapshot:

GET SNAPSHOT FOR DYNAMIC SQL ON database-alias

You will need to turn the Dynamic SQL Monitor switch on in the DBM
configuration for the instance. This is not really a point in time snapshot,
but covers the period from when you turn the monitor switch on until you
take the snapshot. The monitor data can be flushed explicitly with RESET
MONITOR or is cleared when the database is deactivited.

You can output the data to a file or a DB2 table (version 8 only).

See the System Monitor Guide and Reference.