By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,236 Members | 1,455 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,236 IT Pros & Developers. It's quick & easy.

Snapshot Statement Monitor Decode

P: n/a
Can someone assist in decoding the values returned from the snapshot
statement table function ?

Specifically, I am looking to relate the numerical values of
stmt_operation column to a literal.

db2 "select distinct STMT_OPERATION from
table(snapshot_statement('',-1)) as sn_stmt"

STMT_OPERATION
--------------------
5
9
11

3 record(s) selected.
Thank you.

Aug 4 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
mike_dba wrote:
Can someone assist in decoding the values returned from the snapshot
statement table function ?
The best place I've found to get this information is usually from the
sqlmon.h file, which is located in sqllib/include.
STMT_OPERATION
--------------------
5
9
11
For these particular ones:

#define SQLM_FETCH 5 /* SQL Fetch
*/
#define SQLM_STATIC_ROLLBACK 9 /* SQL Static Rollback
*/
#define SQLM_PREP_COMMIT 11 /* Prepare to commit (2-phase
commit)*/

-Chris

Aug 4 '06 #2

P: n/a
Chris,

Thanks for your response. It looks like you have these in a C header
file. Can this be found somewhere? There are many more possible values
that I would like to decode. The ones I originally noted were just a
sample. Thanks
ChrisC wrote:
mike_dba wrote:
Can someone assist in decoding the values returned from the snapshot
statement table function ?

The best place I've found to get this information is usually from the
sqlmon.h file, which is located in sqllib/include.
STMT_OPERATION
--------------------
5
9
11

For these particular ones:

#define SQLM_FETCH 5 /* SQL Fetch
*/
#define SQLM_STATIC_ROLLBACK 9 /* SQL Static Rollback
*/
#define SQLM_PREP_COMMIT 11 /* Prepare to commit (2-phase
commit)*/

-Chris
Aug 8 '06 #3

P: n/a
Chris,

Thank you for the assist. Much apprecaited.
ChrisC wrote:
mike_dba wrote:
Can someone assist in decoding the values returned from the snapshot
statement table function ?

The best place I've found to get this information is usually from the
sqlmon.h file, which is located in sqllib/include.
STMT_OPERATION
--------------------
5
9
11

For these particular ones:

#define SQLM_FETCH 5 /* SQL Fetch
*/
#define SQLM_STATIC_ROLLBACK 9 /* SQL Static Rollback
*/
#define SQLM_PREP_COMMIT 11 /* Prepare to commit (2-phase
commit)*/

-Chris
Aug 8 '06 #4

P: n/a
mike_dba wrote:
Chris,

Thanks for your response. It looks like you have these in a C header
file. Can this be found somewhere? There are many more possible values
that I would like to decode. The ones I originally noted were just a
sample. Thanks
As I mentioned in my e-mail (I have read-only access to this newsgroup
on weekends) - look in sqlmon.h

Jan M. Nelken
Aug 8 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.