Information written to tables for a statement event monitor

Information written by a statement event monitor when the WRITE TO TABLE option is specified.

The sections that follows illustrates the output of a statement event monitor when the WRITE TO TABLE option is used on the CREATE EVENT MONITOR statement. For information about the output returned when the event monitor writes to a file or named pipe, see Event monitor self-describing data stream.
Table 1. Tables produced by STATEMENT write-to-table event monitors. The table name is derived by concatenating the name of the logical data group used to populate the table with the name given to the event monitor (as represented by evmon-name in the table names shown in the following table) in the CREATE EVENT MONITOR statement.
Default table name Logical data groups reported
STMT_evmon-name event_stmt logical data group
CONNHEADER_evmon-name event_connheader logical data group
CONNHEADER_evmon-name event_connheader logical data group
SUBSECTION_evmon-name event_subsection logical data group (only generated in partitioned database environments)
CONTROL_evmon-name The CONTROL logical group consists of selected elements from one or more of the event_dbheader, event_start and event_overflow logical data groups.
To restrict the output of the event monitor to specific tables, specify the names of the logical groups for which you want tables produced in the CREATE EVENT MONITOR or ALTER EVENT MONITOR statements. Refer to the reference topics for those statements for details.

Tables produced

Table 2. Information returned for a statement event monitor: Default table name: STMT_evmon-name
Column name Data type Description
AGENT_ID BIGINT agent_id - Application handle (agent ID)
AGENTS_TOP BIGINT agents_top - Number of agents created
APPL_ID VARCHAR(64) appl_id - Application ID
BLOCKING_CURSOR SMALLINT blocking_cursor - Blocking cursor
CONSISTENCY_TOKEN CHARACTER consistency_token - Package consistency token
CREATOR VARCHAR(128) creator - Application creator
CURSOR_NAME VARCHAR(18) cursor_name - Cursor name
EVMON_FLUSHES BIGINT evmon_flushes - Number of event monitor flushes
FETCH_COUNT BIGINT fetch_count - Number of successful fetches
INT_ROWS_DELETED BIGINT int_rows_deleted - Internal rows deleted
INT_ROWS_INSERTED BIGINT int_rows_inserted - Internal rows inserted
INT_ROWS_UPDATED BIGINT int_rows_updated - Internal rows updated
PACKAGE_NAME VARCHAR(128) package_name - Package name
PACKAGE_VERSION_ID VARCHAR(64) package_version_id - Package version
PARTIAL_RECORD SMALLINT partial_record - Partial record
POOL_DATA_L_READS BIGINT pool_data_l_reads - Buffer pool data logical reads
POOL_DATA_P_READS BIGINT pool_data_p_reads - Buffer pool data physical reads
POOL_INDEX_L_READS BIGINT pool_index_l_reads - Buffer pool index logical reads
POOL_INDEX_P_READS BIGINT pool_index_p_reads - Buffer pool index physical reads
POOL_TEMP_DATA_L_READS BIGINT pool_temp_data_l_reads - Buffer pool temporary data logical reads
POOL_TEMP_DATA_P_READS BIGINT pool_temp_data_p_reads - Buffer pool temporary data physical reads
POOL_TEMP_INDEX_L_READS BIGINT pool_temp_index_l_reads - Buffer pool temporary index logical reads
POOL_TEMP_INDEX_P_READS BIGINT pool_temp_index_p_reads - Buffer pool temporary index physical reads
POOL_TEMP_XDA_L_READS BIGINT pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads
POOL_TEMP_XDA_P_READS BIGINT pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads
POOL_XDA_L_READS BIGINT pool_xda_l_reads - Buffer pool XDA data logical reads
POOL_XDA_P_READS BIGINT pool_xda_p_reads - Buffer pool XDA data physical reads
ROWS_READ BIGINT rows_read - Rows read
ROWS_WRITTEN BIGINT rows_written - Rows written
SECTION_NUMBER BIGINT section_number - Section number
SEQUENCE_NO CHARACTER sequence_no - Sequence number
SORT_OVERFLOWS BIGINT sort_overflows - Sort overflows
SQL_REQ_ID BIGINT sql_req_id - Request identifier for SQL statement
SQLCABC INTEGER See SQLCA (SQL communications area).
SQLCAID CHARACTER See SQLCA (SQL communications area).
SQLCODE INTEGER See SQLCA (SQL communications area).
SQLERRD1 INTEGER See SQLCA (SQL communications area).
SQLERRD2 INTEGER See SQLCA (SQL communications area).
SQLERRD3 INTEGER See SQLCA (SQL communications area).
SQLERRD4 INTEGER See SQLCA (SQL communications area).
SQLERRD5 INTEGER See SQLCA (SQL communications area).
SQLERRD6 INTEGER See SQLCA (SQL communications area).
SQLERRM VARCHAR(72) See SQLCA (SQL communications area).
SQLERRP CHARACTER See SQLCA (SQL communications area).
SQLSTATE CHARACTER See SQLCA (SQL communications area).
SQLWARN CHARACTER See SQLCA (SQL communications area).
START_TIME TIMESTAMP start_time - Event start time
STATS_FABRICATE_TIME BIGINT stats_fabricate_time - Total time spent on statistics fabrication activities
STMT_OPERATION BIGINT  
STMT_TYPE BIGINT stmt_type - Statement type
STOP_TIME TIMESTAMP stop_time - Event stop time
SYNC_RUNSTATS_TIME BIGINT sync_runstats_time - Total time spent on synchronous RUNSTATS activities monitor element
SYSTEM_CPU_TIME BIGINT system_cpu_time - System CPU time
TOTAL_SORT_TIME BIGINT total_sort_time - Total sort time
TOTAL_SORTS BIGINT total_sorts - Total sorts
USER_CPU_TIME BIGINT user_cpu_time - User CPU time
STMT_TEXT CLOB (2097152) stmt_text - SQL statement text
Table 3. Information returned for a statement event monitor: Default table name: CONNHEADER_evmon-name
Column name Data type Description
AGENT_ID BIGINT agent_id - Application handle (agent ID)
APPL_ID VARCHAR(64) appl_id - Application ID
APPL_NAME VARCHAR(255) appl_name - Application name
AUTH_ID VARCHAR(128) auth_id - Authorization ID
CLIENT_DB_ALIAS CHARACTER client_db_alias - Database alias used by application
CLIENT_NNAME VARCHAR(20) client_nname - Client name monitor element
CLIENT_PID BIGINT client_pid - Client process ID
CLIENT_PLATFORM INTEGER client_platform - Client operating platform
CLIENT_PRDID VARCHAR(20) client_prdid - Client product and version ID
CLIENT_PROTOCOL INTEGER client_protocol - Client communication protocol
CODEPAGE_ID INTEGER codepage_id - ID of code page used by application
CONN_TIME TIMESTAMP conn_time - Time of database connection
CORR_TOKEN VARCHAR(64) corr_token - DRDA correlation token
EXECUTION_ID VARCHAR(128) execution_id - User login ID
SEQUENCE_NO CHARACTER sequence_no - Sequence number
TERRITORY_CODE INTEGER territory_code - Database territory code
Table 4. Information returned for a statement event monitor: Default table name: CONTROL_evmon-name
Column name Data type Description
EVENT_MONITOR_NAME VARCHAR(128) event_monitor_name - Event monitor name
MESSAGE VARCHAR(128) message - Control table message
MESSAGE_TIME TIMESTAMP message_time - Timestamp control table message