Using an Event Monitor to Capture Statements with Values for Parameter Markers

You may also like...

12 Responses

  1. Steve says:

    This article was exactly what I was looking for to capture statements for replaying back during regression testing. I do have one issue though… if the sql statement was an insert or an update to a CLOB or BLOB field I don’t see anything in the ACTIVITYVALS_ACT_STMT table. Do you have any idea of where, or even if, that data is captured?

  2. Paul says:

    Hi,

    Sorry to see it was so painful for you, Ember… our docs don’t do a good enough job tying all the pieces together unfortunately. If you get stuck in the future, feel free to ask and I will try to help out. Getting this information out there is critical and your blog really helps. Thanks!

    As for Steve’s question, LOB data values are not captured as per the documentation on the stmt_value_date element:

    stmt_value_data – Value data monitor element

    This element contains a string representation of a data value to an SQL statement. LOB, LONG, and structured type parameters appear as empty strings. Date, time, and timestamp fields are recorded in ISO format.

  3. samir says:

    How to i get the actual application id ?

  4. edu says:

    how can i revert

    db2 “alter service class sysdefaultsubclass under sysdefaultuserclass collect activity data on all database partitions with details and values”

    to default?

  1. October 14, 2014

    […] I started with the same exact setup from Using an Event Monitor to Capture Statements with Values for Parameter Markers. […]

  2. November 25, 2014

    […] system tables or monitoring tables to get information. In that context, I use LISTAGG – see “Using an Event Monitor to Capture Statements with Values for Parameter Markers for one […]

  3. November 3, 2016

    […] Using an Event Monitor to Capture Statements with Values for Parameter Markers […]

  4. August 29, 2017

    […] UOW monitor reference Good IBM refernce Good DB2Commerce reference […]

Leave a Reply

Your email address will not be published. Required fields are marked *