Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008

    Question Unanswered: Help required in creating an event monitor for SQL queries ???


    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.

  2. #2
    Join Date
    May 2003
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts