System Monitor Guide and Reference

Event Monitor Logical Data Groupings

The following table lists the logical data groupings and data elements that can be returned by event monitoring. These correspond to the structures described in Output Records.

Table 6. Event Monitor Logical Data Groups and Data Elements

Event Logical Data Groups	Data Elements	See page
db_event	sec_log_used_top tot_log_used_top rows_read pool_data_l_reads pool_data_p_reads pool_async_data_reads pool_data_writes pool_async_data_writes pool_index_l_reads pool_index_p_reads pool_index_writes pool_async_index_writes pool_read_time pool_write_time pool_async_read_time pool_async_write_time pool_async_data_read_reqs direct_reads direct_writes direct_read_reqs direct_write_reqs direct_read_time direct_write_time pool_async_index_reads pool_data_to_estore pool_index_to_estore pool_index_from_estore pool_data_from_estore lock_waits lock_wait_time deadlocks lock_escals x_lock_escals lock_timeouts total_sorts total_sort_time sort_overflows pool_lsn_gap_clns pool_drty_pg_steal_clns pool_drty_pg_thrsh_clns files_closed commit_sql_stmts rollback_sql_stmts dynamic_sql_stmts static_sql_stmts failed_sql_stmts select_sql_stmts	Maximum Secondary Log Space Used Maximum Total Log Space Used Rows Read Buffer Pool Data Logical Reads Buffer Pool Data Physical Reads Buffer Pool Asynchronous Data Reads Buffer Pool Data Writes Buffer Pool Asynchronous Data Writes Buffer Pool Index Logical Reads Buffer Pool Index Physical Reads Buffer Pool Index Writes Buffer Pool Asynchronous Index Writes Total Buffer Pool Physical Read Time Total Buffer Pool Physical Write Time Buffer Pool Asynchronous Read Time Buffer Pool Asynchronous Write Time Buffer Pool Asynchronous Read Requests Direct Reads From Database Direct Writes to Database Direct Read Requests Direct Write Requests Direct Read Time Direct Write Time Buffer Pool Asynchronous Index Reads Buffer Pool Data Pages to Extended Storage Buffer Pool Index Pages to Extended Storage Buffer Pool Index Pages from Extended Storage Buffer Pool Data Pages from Extended Storage Lock Waits Time Waited On Locks Deadlocks Detected Number of Lock Escalations Exclusive Lock Escalations Number of Lock Timeouts Total Sorts Total Sort Time Sort Overflows Buffer Pool Log Space Cleaners Triggered Buffer Pool Victim Page Cleaners Triggered Buffer Pool Threshold Cleaners Triggered Database Files Closed Commit Statements Attempted Rollback Statements Attempted Dynamic SQL Statements Attempted Static SQL Statements Attempted Failed Statement Operations Select SQL Statements Executed
db_event (continued)	ddl_sql_stmts uid_sql_stmts int_auto_rebinds int_rows_deleted int_rows_updated int_rows_inserted int_commits int_rollbacks rows_deleted rows_inserted rows_updated rows_selected binds_precompiles total_cons connections_top db_heap_top log_reads log_writes pkg_cache_lookups pkg_cache_inserts cat_cache_lookups cat_cache_inserts cat_cache_overflows cat_cache_heap_full appl_section_lookups appl_section_inserts prefetch_wait_time catalog_node total_hash_joins total_hash_loops hash_join_overflows hash_join_small_overflows pkg_cache_num_overflows pkg_cache_size_top disconn_time server_platform catalog_node_name partial_record	Data Definition Language (DDL) SQL Statements Update/Insert/Delete SQL Statements Executed Internal Automatic Rebinds Internal Rows Deleted Internal Rows Updated Internal Rows Inserted Internal Commits Internal Rollbacks Rows Deleted Rows Inserted Rows Updated Rows Selected Binds/Precompiles Attempted Connects Since Database Activation Maximum Number of Concurrent Connections Maximum Database Heap Allocated Number of Log Pages Read Number of Log Pages Written Package Cache Lookups Package Cache Inserts Catalog Cache Lookups Catalog Cache Inserts Catalog Cache Overflows Catalog Cache Heap Full Section Lookups Section Inserts Time Waited for Prefetch Catalog Node Number Total Hash Joins Total Hash Loops Hash Join Overflows Hash Join Small Overflows Package Cache Overflows Maximum Package Cache Size Database Deactivation Timestamp Server Operating System Catalog Node Network Name Partial Record
dbheader_event	conn_time db_name db_path	Time of Database Connection Database Name Database Path
connheader_event	client_pid agent_id conn_time codepage_id country_code client_platform client_protocol node_number appl_id sequence_no corr_token appl_name auth_id execution_id client_nname client_prdid client_db_alias	Client Process ID Application Handle (agent ID) Time of Database Connection ID of Code Page Used by Application Database Country Code Client Operating Platform Client Communication Protocol Node Number Application ID Sequence Number DRDA Correlation Token Application Name Authorization ID User Login ID Configuration NNAME of Client Client Product/Version ID Database Alias Used by Application
start_event	start_time	Event Start Time
deadlock_event	dl_conns rolled_back_agent_id start_time rolled_back_appl_id rolled_back_sequence_no	Connections Involved in Deadlock Rolled Back Agent Event Start Time Rolled Back Application Rolled Back Sequence Number
dlconn_event	lock_mode lock_object_type lock_object_name lock_node agent_id lock_mode_requested lock_wait_start_time start_time lock_escalation appl_id sequence_no appl_id_holding_lk sequence_no_holding_lk table_name table_schema tablespace_name	Lock Mode Lock Object Type Waited On Lock Object Name Lock Node Application Handle (agent ID) Lock Mode Requested Lock Wait Start Timestamp Event Start Time Lock Escalation Application ID Sequence Number Application ID Holding Lock Sequence Number Holding Lock Table Name Table Schema Name Table Space Name
table_event	rows_written rows_read overflow_accesses table_type page_reorgs event_time table_name table_schema partial_record	Rows Written Rows Read Accesses to Overflowed Records Table Type Page Reorganizations Event Time Table Name Table Schema Name Partial Record
tablespace_event	pool_data_l_reads pool_data_p_reads pool_async_data_reads pool_data_writes pool_async_data_writes pool_index_l_reads pool_index_p_reads pool_index_writes pool_async_index_writes pool_read_time pool_write_time pool_async_read_time pool_async_write_time pool_async_data_read_reqs direct_reads direct_writes direct_read_reqs direct_write_reqs direct_read_time direct_write_time pool_async_index_reads pool_data_to_estore pool_index_to_estore pool_index_from_estore pool_data_from_estore files_closed event_time tablespace_name partial_record	Buffer Pool Data Logical Reads Buffer Pool Data Physical Reads Buffer Pool Asynchronous Data Reads Buffer Pool Data Writes Buffer Pool Asynchronous Data Writes Buffer Pool Index Logical Reads Buffer Pool Index Physical Reads Buffer Pool Index Writes Buffer Pool Asynchronous Index Writes Total Buffer Pool Physical Read Time Total Buffer Pool Physical Write Time Buffer Pool Asynchronous Read Time Buffer Pool Asynchronous Write Time Buffer Pool Asynchronous Read Requests Direct Reads From Database Direct Writes to Database Direct Read Requests Direct Write Requests Direct Read Time Direct Write Time Buffer Pool Asynchronous Index Reads Buffer Pool Data Pages to Extended Storage Buffer Pool Index Pages to Extended Storage Buffer Pool Index Pages from Extended Storage Buffer Pool Data Pages from Extended Storage Database Files Closed Event Time Table Space Name Partial Record
conn_event	rows_read rows_written pool_data_l_reads pool_data_p_reads pool_data_writes pool_index_l_reads pool_index_p_reads pool_index_writes pool_read_time pool_write_time direct_reads direct_writes direct_read_reqs direct_write_reqs direct_read_time direct_write_time pool_data_to_estore pool_index_to_estore pool_index_from_estore pool_data_from_estore lock_waits lock_wait_time lock_escals x_lock_escals deadlocks lock_timeouts total_sorts total_sort_time sort_overflows commit_sql_stmts rollback_sql_stmts dynamic_sql_stmts static_sql_stmts failed_sql_stmts select_sql_stmts ddl_sql_stmts uid_sql_stmts int_auto_rebinds int_rows_deleted int_rows_updated int_rows_inserted int_commits int_rollbacks int_deadlock_rollbacks rows_deleted rows_inserted rows_updated rows_selected	Rows Read Rows Written Buffer Pool Data Logical Reads Buffer Pool Data Physical Reads Buffer Pool Data Writes Buffer Pool Index Logical Reads Buffer Pool Index Physical Reads Buffer Pool Index Writes Total Buffer Pool Physical Read Time Total Buffer Pool Physical Write Time Direct Reads From Database Direct Writes to Database Direct Read Requests Direct Write Requests Direct Read Time Direct Write Time Buffer Pool Data Pages to Extended Storage Buffer Pool Index Pages to Extended Storage Buffer Pool Index Pages from Extended Storage Buffer Pool Data Pages from Extended Storage Lock Waits Time Waited On Locks Lock Escalation Exclusive Lock Escalations Deadlocks Detected Number of Lock Timeouts Total Sorts Total Sort Time Sort Overflows Commit Statements Attempted Rollback Statements Attempted Dynamic SQL Statements Attempted Static SQL Statements Attempted Failed Statement Operations Select SQL Statements Executed Data Definition Language (DDL) SQL Statements Update/Insert/Delete SQL Statements Executed Internal Automatic Rebinds Internal Rows Deleted Internal Rows Updated Internal Rows Inserted Internal Commits Internal Rollbacks Internal Rollbacks Due To Deadlock Internal Rows Deleted Internal Rows Inserted Internal Rows Updated Rows Selected
conn_event (continued)	binds_precompiles rej_curs_blk acc_curs_blk pkg_cache_lookups pkg_cache_inserts cat_cache_overflows cat_cache_heap_full appl_section_lookups appl_section_inserts prefetch_wait_time authority_lvl coord_node appl_priority_type agent_id total_hash_joins total_hash_loops hash_join_overflows hash_join_small_overflows cat_cache_inserts cat_cache_lookups appl_priority disconn_time user_cpu_time system_cpu_time appl_id sequence_no partial_record	Binds/Precompiles Attempted Rejected Block Cursor Requests Accepted Block Cursor Requests Package Cache Lookups Package Cache Inserts Catalog Cache Overflows Catalog Cache Heap Full Section Lookups Section Inserts Time Waited for Prefetch User Authorization Level Secondary Connections Application Priority Type Application Handle (agent ID) Total Hash Joins Total Hash Loops Hash Join Overflows Hash Join Small Overflows Catalog Cache Inserts Catalog Cache Lookups Application Agent Priority Database Deactivation Timestamp User CPU Time System CPU Time Application ID Sequence Number Partial Record
sqlca	sqlcabc sqlcode sqlerrml sqlcaid sqlerrmc sqlerrp sqlerrd sqlwarn sqlstate	see the Administrative API Reference see the Administrative API Reference see the Administrative API Reference see the Administrative API Reference see the Administrative API Reference see the Administrative API Reference see the Administrative API Reference see the Administrative API Reference see the Administrative API Reference
stmt_event	rows_read rows_written stmt_type stmt_operation fetch_count section_number total_sorts total_sort_time sort_overflows int_rows_deleted int_rows_updated int_rows_inserted agent_id agents_top start_time stop_time user_cpu_time system_cpu_time blocking_cursor sqlca cursor_name creator package_name appl_id sequence_no partial_record stmt_text	Rows Read Rows Written Statement Type Statement Operation Number of Successful Fetches Section Number Total Sorts Total Sort Time Sort Overflows Internal Rows Deleted Internal Rows Updated Internal Rows Inserted Application Handle (agent ID) Number of Agents Created Event Start Time Event Stop Time User CPU Time System CPU Time Blocking Cursor SQL Communications Area (SQLCA) Cursor Name Application Creator Package Name Application ID Sequence Number Partial Record SQL Dynamic Statement Text
subsection_event	agent_id ss_exec_time tq_tot_send_spills tq_max_send_spills tq_rows_read tq_rows_written ss_usr_cpu_time ss_sys_cpu_time ss_number ss_node_number num_agents partial_record	Application Handle (agent ID) Subsection Execution Elapsed Time Total Number of Tablequeue Buffers Overflowed "Maximum Number of Tablequeue Buffers Overflows" Number of Rows Read from Tablequeues Number of Rows Written to Tablequeues User CPU Time used by Subsection System CPU Time used by Subsection Subsection Number Subsection Node Number Number of Agents Working on a Statement Partial Record
xaction_event	rows_read rows_written uow_log_space_used uow_status lock_wait_time locks_held_top lock_escals x_lock_escal agent_id user_cpu_time system_cpu_time prev_uow_stop_time uow_start_time uow_stop_time appl_id sequence_no partial_record	Rows Read Rows Written Unit of Work Log Space Used Unit of Work Status Time Waited On Locks Maximum Number of Locks Held Number of Lock Escalations Exclusive Lock Escalations Application Handle (agent ID) User CPU Time System CPU Time Previous Unit of Work Completion Timestamp Unit of Work Start Timestamp Unit of Work Stop Timestamp Application ID Sequence Number Partial Record
bufferpool_event	pool_data_l_reads pool_data_p_reads pool_data_writes pool_index_l_reads pool_index_p_reads pool_index_writes pool_read_time pool_write_time pool_async_data_reads pool_async_data_writes pool_async_index_writes pool_async_read_time pool_async_write_time pool_async_data_read_reqs direct_reads direct_writes direct_read_reqs direct_write_reqs direct_read_time direct_write_time pool_async_index_reads pool_data_to_estore pool_index_to_estore pool_index_from_estore pool_data_from_estore files_closed event_time bp_name db_name db_path partial_record	Buffer Pool Data Logical Reads Buffer Pool Data Physical Reads Buffer Pool Data Writes Buffer Pool Index Logical Reads Buffer Pool Index Physical Reads Buffer Pool Index Writes Total Buffer Pool Physical Read Time Total Buffer Pool Physical Write Time Buffer Pool Asynchronous Data Reads Buffer Pool Asynchronous Data Writes Buffer Pool Asynchronous Index Writes Buffer Pool Asynchronous Read Time Buffer Pool Asynchronous Write Time Buffer Pool Asynchronous Read Requests Direct Reads From Database Direct Writes to Database Direct Read Requests Direct Write Requests Direct Read Time Direct Write Time Buffer Pool Asynchronous Index Reads Buffer Pool Data Pages to Extended Storage Buffer Pool Index Pages to Extended Storage Buffer Pool Index Pages from Extended Storage Buffer Pool Data Pages from Extended Storage Database Files Closed Event Time Bufferpool Name Database Name Database Path Partial Record
overflow_event	count first_overflow_time last_overflow_time node_number	Number of Event Monitor Overflows Time of First Event Overflow Time of Last Event Overflow Node Number
log_header_event	byte_order version num_nodes_in_db2_instance codepage_id country_code server_prdid server_instance_name event_monitor_name	Byte Order of Event Data Version of Monitor Data Number of Nodes in Partition ID of Code Page Used by Application Database Country Code Server Product/Version ID Server Instance Name Event Monitor Name