IBM Books

Type of Event Monitor Data


Event Information Level
Event Log Header
 
Database
 
Connection
 
Table Space
 
Table
Transaction
Deadlock
 
Statement
 

API Structure(s)
sqlm_reset_event
sqlm_overflow_event
sqlm_db_event
sqlm_dbheader_event
sqlm_conn_event
sqlm_connheader_event
sqlm_tablespace_event
sqlm_bufferpool_event
sqlm_table_event
sqlm_xaction_event
sqlm_deadlock_event
sqlm_dlconn_event
sqlm_stmt_event
sqlm_stmttext_event

 

API Element Name
Element Type

event_type
information

 

Description:  The type of event monitor data being returned.

Usage:  Applications that read database system monitor information should always use this field to determine the type of information that is being returned by the monitor, and to determine the API structure to use. The following table shows the API constants and the event monitor data structure you should use to interpret the record.

API Constant
API Data Structure
SQLM_EVENT_DB
sqlm_db_event
SQLM_EVENT_CONN
sqlm_conn_event
SQLM_EVENT_TABLE
sqlm_table_event
SQLM_EVENT_STMT
sqlm_stmt_event
SQLM_EVENT_STMTTEXT
sqlm_stmttext_event
SQLM_EVENT_XACT
sqlm_xaction_event
SQLM_EVENT_DEADLOCK
sqlm_deadlock_event
SQLM_EVENT_DLCONN
sqlm_dlconn_event
SQLM_EVENT_TABLESPACE
sqlm_tablespace_event
SQLM_EVENT_DBHEADER
sqlm_dbheader_event
SQLM_EVENT_RESET
sqlm_reset_event
SQLM_EVENT_CONNHEADER
sqlm_connheader_event
SQLM_EVENT_OVERFLOW
sqlm_overflow_event

This element is in the same position in all event monitor data records.

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

[ DB2 List of Books | Search the DB2 Books ]