DB2 Help

Statement Type

Snapshot Level Application	Logical Data Grouping appl stmt	Monitor Switch Statement Statement
Resettable	No
Event Type Statement	Logical Data Grouping stmt_event
Element Name Element Type	stmt_type information

Description: The type of statement processed.

Usage: You can use this element to determine the type of statement that is executing. It can be one of the following:

A static SQL statement
A dynamic SQL statement
An operation other than an SQL statement; for example, a bind or pre-compile operation.

For the snapshot monitor, this element describes the statement that is currently being processed or was most recently processed.
Note: API users should refer to the sqlmon.h header file containing definitions of database system monitor constants.