Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / April 2005

Tip: Looking for answers? Try searching our database.

showing actual values in sql statement event monitor

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
brandon - 28 Mar 2005 18:14 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
)
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.