Information written to tables for a connections event monitor

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

When you choose WRITE TO TABLE as the ouput type for the connections event monitor, by default, four tables are produced, each containing monitor elements from one or more logical data groups:
Table 1. Tables produced by CONNECTIONS 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
CONNHEADER_evmon-name event_connheader
CONN_evmon-name event_conn
CONMEMUSE_evmon-name event_connmemuse
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.

For information about the output returned when the event monitor writes to a file or named pipe, see Event monitor self-describing data stream.

Tables produced

Table 2. Information returned for a connections 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 CHAR(8) 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 CHAR(5) sequence_no - Sequence number
TERRITORY_CODE INTEGER territory_code - Database territory code
Table 3. Information returned for a connections event monitor: Table name: CONN_evmon-name
Column Name Data Type Description
ACC_CURS_BLK BIGINT acc_curs_blk - Accepted block cursor requests
AGENT_ID BIGINT agent_id - Application handle (agent ID)
APPL_ID VARCHAR(64) appl_id - Application ID
APPL_PRIORITY BIGINT appl_priority - Application agent priority
APPL_PRIORITY_TYPE BIGINT appl_priority_type - Application priority type
APPL_SECTION_INSERTS BIGINT appl_section_inserts - Section inserts
APPL_SECTION_LOOKUPS BIGINT appl_section_lookups - Section lookups
APPL_STATUS BIGINT appl_status - Application status
AUTHORITY_BITMAP CHARACTER(22) authority_bitmap - User authorization level
AUTHORITY_LVL BIGINT authority_lvl - User authorization level
BINDS_PRECOMPILES BIGINT binds_precompiles - Binds/precompiles attempted
CAT_CACHE_HEAP_FULL BIGINT cat_cache_heap_full - Catalog cache heap full
CAT_CACHE_INSERTS BIGINT cat_cache_inserts - Catalog cache inserts
CAT_CACHE_LOOKUPS BIGINT cat_cache_lookups - Catalog cache lookups
CAT_CACHE_OVERFLOWS BIGINT cat_cache_overflows - Catalog cache overflows
CAT_CACHE_SIZE_TOP BIGINT cat_cache_size_top - Catalog cache high watermark
COMMIT_SQL_STMTS BIGINT commit_sql_stmts - Commit statements attempted
COORD_NODE BIGINT coord_node - Coordinating node
DDL_SQL_STMTS BIGINT ddl_sql_stmts - Data definition language (DDL) SQL statements
DEADLOCKS BIGINT deadlocks - Deadlocks detected
DIRECT_READ_REQS BIGINT direct_read_reqs - Direct read requests
DIRECT_READ_TIME BIGINT direct_read_time - Direct read time
DIRECT_READS BIGINT direct_reads - Direct reads from database
DIRECT_WRITE_REQS BIGINT direct_write_reqs - Direct write requests
DIRECT_WRITE_TIME BIGINT direct_write_time - Direct write time
DIRECT_WRITES BIGINT direct_writes - Direct writes to database
DISCONN_TIME TIMESTAMP disconn_time - Database deactivation timestamp
DYNAMIC_SQL_STMTS BIGINT dynamic_sql_stmts - Dynamic SQL statements attempted
ELAPSED_EXEC_TIME BIGINT elapsed_exec_time - Statement execution elapsed time
EVMON_FLUSHES BIGINT evmon_flushes - Number of event monitor flushes
FAILED_SQL_STMTS BIGINT failed_sql_stmts - Failed statement operations
HASH_JOIN_OVERFLOWS BIGINT hash_join_overflows - Hash join overflows
HASH_JOIN_SMALL_OVERFLOWS BIGINT hash_join_small_overflows - Hash join small overflows
INT_AUTO_REBINDS BIGINT int_auto_rebinds - Internal automatic rebinds
INT_COMMITS BIGINT int_commits - Internal commits
INT_DEADLOCK_ROLLBACKS BIGINT int_deadlock_rollbacks - Internal rollbacks due to deadlock
INT_ROLLBACKS BIGINT int_rollbacks - Internal rollbacks
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
LOCK_ESCALS BIGINT lock_escals - Number of lock escalations
LOCK_TIMEOUTS BIGINT lock_timeouts - Number of lock timeouts
LOCK_WAIT_TIME BIGINT lock_wait_time - Time waited on locks
LOCK_WAITS BIGINT lock_waits - Lock waits
OLAP_FUNC_OVERFLOWS BIGINT olap_func_overflows - OLAP function overflows
PARTIAL_RECORD SMALLINT partial_record - Partial record
PKG_CACHE_INSERTS BIGINT pkg_cache_inserts - Package cache inserts
PKG_CACHE_LOOKUPS BIGINT pkg_cache_lookups - Package cache lookups
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_DATA_WRITES BIGINT pool_data_writes - Buffer pool data writes
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_INDEX_WRITES BIGINT pool_index_writes - Buffer pool index writes
POOL_READ_TIME BIGINT pool_read_time - Total buffer pool physical read time
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_WRITE_TIME BIGINT pool_write_time - Total buffer pool physical write time
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
POOL_XDA_WRITES BIGINT pool_xda_writes - Buffer pool XDA data writes
PREFETCH_WAIT_TIME BIGINT prefetch_wait_time - Time waited for prefetch
REJ_CURS_BLK BIGINT rej_curs_blk - Rejected block cursor requests
ROLLBACK_SQL_STMTS BIGINT rollback_sql_stmts - Rollback statements attempted
ROWS_DELETED BIGINT rows_deleted - Rows deleted
ROWS_INSERTED BIGINT rows_inserted - Rows inserted
ROWS_READ BIGINT rows_read - Rows read
ROWS_SELECTED BIGINT rows_selected - Rows selected
ROWS_UPDATED BIGINT rows_updated - Rows updated
ROWS_WRITTEN BIGINT rows_written - Rows written
SELECT_SQL_STMTS BIGINT select_sql_stmts - Select SQL statements executed
SEQUENCE_NO CHARACTER(5) sequence_no - Sequence number
SORT_OVERFLOWS BIGINT sort_overflows - Sort overflows
STATIC_SQL_STMTS BIGINT static_sql_stmts - Static SQL statements attempted
SYSTEM_CPU_TIME BIGINT system_cpu_time - System CPU time
TOTAL_HASH_JOINS BIGINT total_hash_joins - Total hash joins
TOTAL_HASH_LOOPS BIGINT total_hash_loops - Total hash loops
TOTAL_OLAP_FUNCS BIGINT total_olap_funcs - Total OLAP functions
TOTAL_SORT_TIME BIGINT total_sort_time - Total sort time
TOTAL_SORTS BIGINT total_sorts - Total sorts
UID_SQL_STMTS BIGINT uid_sql_stmts - UPDATE/INSERT/DELETE SQL statements executed
UNREAD_PREFETCH_PAGES BIGINT unread_prefetch_pages - Unread prefetch pages
USER_CPU_TIME BIGINT user_cpu_time - User CPU time
X_LOCK_ESCALS BIGINT x_lock_escals - Exclusive lock escalations
XQUERY_STMTS BIGINT xquery_stmts - XQuery Statements Attempted
Table 4. Information returned for a connections event monitor: Table name: CONMEMUSE_evmon-name
Column name Data type Description
APPL_ID VARCHAR(64) appl_id - Application ID
EVMON_FLUSHES BIGINT evmon_flushes - Number of event monitor flushes
POOL_CUR_SIZE BIGINT pool_cur_size - Current size of memory pool
POOL_ID BIGINT pool_id - Memory pool identifier
POOL_LIST_ID BIGINT  
POOL_MAX_SIZE BIGINT  
POOL_WATERMARK BIGINT pool_watermark - Memory pool watermark
Table 5. Information returned for a connections event monitor: Default table name: CONTROL_evmon-name
Column Name Data Type Description
APPL_ID VARCHAR(64) appl_id - Application ID
EVMON_FLUSHES BIGINT evmon_flushes - Number of event monitor flushes
POOL_CUR_SIZE BIGINT pool_cur_size - Current size of memory pool
POOL_ID BIGINT pool_id - Memory pool identifier
POOL_LIST_ID BIGINT  
POOL_MAX_SIZE BIGINT  
POOL_WATERMARK BIGINT pool_watermark - Memory pool watermark