Hello,

I have an application that uses DB2 as database running in a remote linux server. I use windows telnet to manage the database via shell for testing purposes.

What is the exact procedure of creating an event monitor for getting the information regarding SQL queries executed by my application on the database ?

Thanks for the help.

To be honest, I don't how to do this with an event monitor. If the queries are dynamic SQL instead of embeded static SQL, using a "get snapshot for dynamic SQL ..." is the easiest way to do this. You will need to turn on the statement monitor at the instance level, or turn it on only for that session using "update monitor switches...".

Dynamic SQL would be used for any Java interface or script. Static SQL is used in an SQL stored procedure, function, or triggers, or in a language such as C where the program is compiled and a bind is done on the associated DB2 package.