Snapshot Statement Monitor Decode

[mike_dba]

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.

[ChrisC]

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

[mike_dba]

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

[mike_dba]

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

[Jan M. Nelken]

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