Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    14

    Unanswered: get SQL statement executed from an application

    Hi everybody,

    Is possible to get the complete SQL statement executed from an application???
    We need to generate a file with all the SQL statements executed on the database. Even if a simple SELECT is executed.
    If it's possible, what I need to do???

    Host:AIX
    Client:Linux
    DBB2 v7.1.0.41

    Thanks in advance!!!

    Monica.

  2. #2
    Join Date
    Jan 2002
    Location
    Manila, Philippines
    Posts
    71

    Event Monitor

    define an Event Monitor for Statements ...

    this will capture all statement executed vs the db (along with other details), use DB2EVMON to pipe the output to a (text) file.

    hth,
    oliver

  3. #3
    Join Date
    Aug 2002
    Posts
    14

    Re: Event Monitor

    Hi Oliver,

    Thanks very much for your attention, helped me a lot.

    Monica.

Posting Permissions

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