I've followed the instructions here
(http://groups-beta.google.com/group/comp.databases.ibm-db2/browse_frm/thread/1f6
9a5fecafba8d8/c35658a24456ad87?tvc=1&q=db2+statement+event+monitor#c35658a24456a
d87)
to enable sql tracing w/ DB2 8.1. However, when I view the db2evmon
output, the values in the queries have been replaced by question marks.
For example:
65) Statement Event ...
Appl Handle: 14
Appl Id: GA990C3C.B410.00F1C5212311
Appl Seq number: 0012
Record is the result of a flush: FALSE
-------------------------------------------
Type : Dynamic
Operation: Execute
Section : 6
Creator : NULLID
Package : SYSSN300
Consistency Token : SYSLVL01
Package Version ID :
Cursor : SQL_CURSN300C6
Cursor was blocking: FALSE
Text : INSERT INTO GENERICEVENTLOG VALUES
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
I would expect the question marks to be replaced by the actual values
that were inserted at the time of the query. Is there any way to
accomplish this?
Serge Rielau - 29 Mar 2005 01:04 GMT
> I've followed the instructions here
> (http://groups-beta.google.com/group/comp.databases.ibm-db2/browse_frm/thread/1f6
9a5fecafba8d8/c35658a24456ad87?tvc=1&q=db2+statement+event+monitor#c35658a24456a
d87)
[quoted text clipped - 25 lines]
> that were inserted at the time of the query. Is there any way to
> accomplish this?
Not in DB2 V8.2.1.
Cheers
Serge

Signature
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Erik Hendrix - 01 Apr 2005 21:34 GMT
Hey Serge,
About UDB 8.2.2? :-) Or any higher release?
> > I've followed the instructions here
(http://groups-beta.google.com/group/comp.databases.ibm-db2/browse_frm/threa
d/1f69a5fecafba8d8/c35658a24456ad87?tvc=1&q=db2+statement+event+monitor#c356
58a24456ad87)
> > to enable sql tracing w/ DB2 8.1. However, when I view the db2evmon
> > output, the values in the queries have been replaced by question marks.
[quoted text clipped - 28 lines]
> Cheers
> Serge