IBM Books

Statement Operation


Snapshot Information Level
Application

API Structure(s)
sqlm_appl
sqlm_stmt

Monitor Group
Statement
Statement

Resettable

No

 

Event Information Level
Statement

API Structure(s)
sqlm_stmt_event

 

API Element Name
 
Element Type

stmt_operations (Snapshot)
operation (Event)
information

 

Description:  The statement operation currently being processed or most recently processed.

Usage:  Using the snapshot monitor, you can use this element to determine the operation that is executing.

For event monitors, only one event is recorded for all successful fetches for a statement. An event is also recorded for cursors that are implicitly closed at the end of a transaction. The statement operation may be one of the following:

Note:API users should refer to the header file containing definitions of database system monitor constants.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]