Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369

    Unanswered: How to find out parameter marker/host variable values used in queries

    I'm aware of the following options:
    - CLI trace
    - JDBC trace
    - db2trc


    Is there some other way?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Event monitor for statements?

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Forgot about event monitor. Thx. I think I've seen some statement event monitors with parameter markers and some with the actual values. I think it depends on the reopt option used? I'll need to take a look at it again.


    I also found the following after posting my question:

    "When you audit using the EXECUTE category, the statement text for both static and dynamic SQL is recorded, as are input parameter markers and
    host variables. You can configure the EXECUTE category to be audited with or without input values."

    IBM DB2 9.7 for Linux, UNIX and Windows Information Center


    I don't know much about db2audit, but it sounds like this should do it.

Posting Permissions

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