System Monitor Guide and Reference

Appendix B. Logical Data Groupings

The following tables list the logical data groupings and the data elements associated with Snapshot and Event Monitoring.

Table 5. Snapshot Monitor Logical Data Groups and Data Elements

Snapshot Logical Data Groups	Data Elements	See page
collected	server_db2_type server_version time_zone_disp time_stamp node_number server_prdid server_nname server_instance_name server_switch_list	Database Manager Type at Monitored (Server) Node Server Version Time Zone Displacement Snapshot Time Node Number Server Product/Version ID Configuration NNAME at Monitoring (Server) Node Server Instance Name "Monitor Switches Control Data Collected by the Database Manager"
db2	sort_heap_allocated post_threshold_sorts piped_sorts_requested piped_sorts_accepted rem_cons_in rem_cons_in_exec local_cons local_cons_in_exec con_local_dbases agents_registered agents_waiting_on_token db2_status agents_registered_top agents_waiting_top comm_private_mem idle_agents agents_from_pool agents_created_empty_pool coord_agents_top max_agent_overflows agents_stolen gw_total_cons gw_cur_cons gw_cons_wait_host gw_cons_wait_client post_threshold_hash_joins inactive_gw_agents num_gw_conn_switches db2start_time last_reset server_switch_list num_nodes_in_db2_instance product_name component_id service_level	Total Sort Heap Allocated Post Threshold Sorts Piped Sorts Requested Piped Sorts Accepted Remote Connections To Database Manager Remote Connections Executing in the Database Manager Local Connections Local Connections Executing in the Database Manager Local Databases with Current Connects Agents Registered Agents Waiting for a Token Status of Database Maximum Number of Agents Registered Maximum Number of Agents Waiting Committed Private Memory Number of Idle Agents Agents Assigned From Pool Agents Created Due to Empty Agent Pool Maximum Number of Coordinating Agents Maximum Agent Overflows Stolen Agents Total Number of Attempted Connections for DB2 Connect Current Number of Connections for DB2 Connect Number of Connections Waiting for the Host to Reply "Number of Connections Waiting for the Client to Send Request" Hash Join Threshold Total Inactive DRDA Agents Connection Switches Start Database Manager Timestamp Last Reset Timestamp "Monitor Switches Control Data Collected by the Database Manager" Number of Nodes in Partition Product Name Product Identification Service Level
fcm	buff_free buff_free_bottom MA_free MA_free_bottom CE_free CE_free_bottom RB_free RB_free_bottom	FCM Buffers Currently Free Minimum FCM Buffers Free Message Anchors Currently Free Minimum Message Anchors Connection Entries Currently Free Minimum Connection Entries Request Blocks Currently Free Minimum Request Blocks
fcm_node	connection_status total_buffers_sent total_buffers_rcvd node_number	Connection Status Total FCM Buffers Sent Total FCM Buffers Received Node Number
dynsql	num_executions num_compilations prep_time_worst prep_time_best int_rows_deleted int_rows_inserted rows_read int_rows_updated rows_written stmt_sorts total_exec_time tot_s_cpu_time tot_u_cpu_time stmt_text	Statement Executions Statement Compilations Statement Worst Preparation Time Statement Best Preparation Time Internal Rows Deleted Internal Rows Inserted Rows Read Internal Rows Updated Rows Written Statement Sorts Elapsed Statement Execution Time Total System CPU for a Statement Total User CPU for a Statement SQL Dynamic Statement Text
dbase	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 files_closed pool_async_index_reads pool_data_to_estore pool_index_to_estore pool_index_from_estore pool_data_from_estore 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_lsn_gap_clns pool_drty_pg_steal_clns pool_drty_pg_thrsh_clns locks_held lock_waits lock_wait_time lock_list_in_use deadlocks lock_escals x_lock_escals locks_waiting sort_heap_allocated total_sorts total_sort_time sort_overflows active_sorts commit_sql_stmts rollback_sql_stmts dynamic_sql_stmts static_sql_stmts	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 Database Files Closed 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 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 Log Space Cleaners Triggered Buffer Pool Victim Page Cleaners Triggered Buffer Pool Threshold Cleaners Triggered Locks Held Lock Waits Time Waited On Locks Total Lock List Memory In Use Deadlocks Detected Number of Lock Escalations Exclusive Lock Escalations Current Agents Waiting On Locks Total Sort Heap Allocated Total Sorts Total Sort Time Sort Overflows Active Sorts Commit Statements Attempted Rollback Statements Attempted Dynamic SQL Statements Attempted Static SQL Statements Attempted
dbase (continued)	failed_sql_stmts select_sql_stmts ddl_sql_stmts uid_sql_stmts int_auto_rebinds int_rows_deleted int_rows_updated int_commits int_rollbacks int_deadlock_rollbacks rows_deleted rows_inserted rows_updated rows_selected binds_precompiles total_cons appls_cur_cons appls_in_db2 sec_log_used_top tot_log_used_top sec_logs_allocated db_status lock_timeouts connections_top db_heap_top int_rows_inserted log_reads log_writes pkg_cache_lookups pkg_cache_inserts cat_cache_lookups cat_cache_inserts cat_cache_overflows cat_cache_heap_full catalog_node total_sec_cons num_assoc_agents agents_top coord_agents_top prefetch_wait_time appl_section_lookups appl_section_inserts total_hash_joins total_hash_loops hash_join_overflows hash_join_small_overflows	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 Commits Internal Rollbacks Internal Rollbacks Due To Deadlock Rows Deleted Rows Inserted Rows Updated Rows Selected Binds/Precompiles Attempted Connects Since Database Activation Applications Connected Currently Applications Executing in the Database Currently Maximum Secondary Log Space Used Maximum Total Log Space Used Secondary Logs Allocated Currently Status of Database Number of Lock Timeouts Maximum Number of Concurrent Connections Maximum Database Heap Allocated Internal Rows Inserted 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 Catalog Node Number Secondary Connections Number of Associated Agents Number of Agents Created Maximum Number of Coordinating Agents Time Waited for Prefetch Section Lookups Section Inserts Total Hash Joins Total Hash Loops Hash Join Overflows Hash Join Small Overflows
dbase (continued)	pkg_cache_num_overflows pkg_cache_size_top total_log_used total_log_available db_conn_time last_reset last_backup db_location server_platform appl_id_oldest_xact catalog_node_name input_db_alias db_name db_path	Package Cache Overflows Maximum Package Cache Size Total Log Space Used Total Log Available Database Activation Timestamp Last Reset Timestamp Last Backup Timestamp Database Location Server Operating System Application with Oldest Transaction Catalog Node Network Name Input Database Alias Database Name Database Path
rollforward	rf_type rf_log_num rf_status rf_timestamp node_number ts_name	Rollforward Type Log Being Rolled Forward Log Phase Rollforward Timestamp Node Number Tablespace Being Rolled Forward
table_list	last_reset db_conn_time input_db_alias db_name db_path	Last Reset Timestamp Database Activation Timestamp Input Database Alias Database Name Database Path
table	table_file_id table_type rows_written rows_read overflow_accesses page_reorgs table_name table_schema	Table File ID Table Type Rows Written Rows Read Accesses to Overflowed Records Page Reorganizations Table Name Table Schema Name
tablespace_list	last_reset db_conn_time input_db_alias db_name db_path	Last Reset Timestamp Database Activation Timestamp Input Database Alias Database Name Database Path
tablespace	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 files_closed pool_async_index_reads pool_data_to_estore pool_index_to_estore pool_index_from_estore pool_data_from_estore tablespace_name	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 Database Files Closed 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 Table Space Name
db_lock_list	locks_held appls_cur_cons locks_waiting db_name db_path	Locks Held Applications Connected Currently Current Agents Waiting On Locks Input Database Alias Database Name Database Path
appl_lock_list	agent_id appl_status codepage_id locks_held locks_waiting lock_wait_time status_change_time appl_id sequence_no appl_name auth_id client_db_alias	Application Handle (agent ID) Application Status ID of Code Page Used by Application Locks Held Current Agents Waiting On Locks Time Waited On Locks Application Status Change Time Application ID Sequence Number Application Name Authorization ID Database Alias Used by Application
lock_wait	subsection_number lock_mode lock_object_type agent_id_holding_lk lock_mode_requested lock_wait_start_time lock_escalation table_name table_schema tablespace_name appl_id_holding_lk	Subsection Number Lock Mode Lock Object Type Waited On Agent ID Holding Lock Lock Mode Requested Lock Wait Start Timestamp Lock Escalation Table Name Table Schema Name Table Space Name Application ID Holding Lock
lock	table_file_id lock_object_type lock_mode lock_status lock_object_name lock_escalation table_name table_schema tablespace_name	Table File ID Lock Object Type Waited On Lock Mode Lock Status Lock Object Name Lock Escalation Table Name Table Schema Name Table Space Name
bufferpool	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 files_closed 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 bp_name input_db_alias db_name db_path	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 Database Files Closed 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 Bufferpool Name Input Database Alias Database Name Database Path
appl_info	agent_id appl_status codepage_id num_assoc_agents coord_node_num authority_lvl client_pid coord_agent_pid status_change_time client_platform client_protocol country_code appl_name appl_id sequence_no auth_id client_nname client_prdid input_db_alias client_db_alias db_name db_path execution_id corr_token outbound_comm_address inbound_comm_address	Application Handle (agent ID) Application Status ID of Code Page Used by Application Number of Associated Agents Coordinating Node Authorization ID Client Process ID Coordinator Agent Application Status Change Time Client Operating Platform Client Communication Protocol Database Country Code Application Name Application ID Sequence Number Authorization ID Configuration NNAME of Client Client Product/Version ID Input Database Alias Database Alias Used by Application Database Name Database Path User Login ID DRDA Correlation Token Outbound Communication Address Inbound Communication Address
appl	locks_held lock_waits lock_wait_time lock_escals x_lock_escals deadlocks total_sorts total_sort_time sort_overflows 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 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_commits int_rollbacks int_deadlock_rollbacks rows_deleted rows_inserted rows_updated rows_selected binds_precompiles open_rem_curs open_rem_curs_blk rej_curs_blk	Locks Held Lock Waits Time Waited On Locks Lock Escalation Exclusive Lock Escalations Deadlocks Detected Total Sorts Total Sort Time Sort Overflows 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 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 Commits Internal Rollbacks Internal Rollbacks Due To Deadlock Rows Deleted Rows Inserted Rows Updated Rows Selected Binds/Precompiles Attempted Open Remote Cursors Open Remote Cursors with Blocking Rejected Block Cursor Requests
appl (continued)	acc_curs_blk sql_reqs_since_commit lock_timeouts int_rows_inserted rows_read rows_written open_loc_curs open_loc_curs_blk pkg_cache_lookups pkg_cache_inserts cat_cache_lookups cat_cache_inserts cat_cache_overflows cat_cache_heap_full num_agents agents_stolen associated_agents_top appl_priority appl_priority_type prefetch_wait_time appl_section_lookups appl_section_inserts locks_waiting total_hash_joins total_hash_loops hash_join_overflows hash_join_small_overflows appl_idle_time uow_log_space_used uow_lock_wait_time uow_comp_status agent_usr_cpu_time agent_sys_cpu_time appl_con_time conn_complete_time last_reset uow_start_time uow_stop_time prev_uow_stop_time uow_elapsed_time	Accepted Block Cursor Requests SQL Requests Since Last Commit Number of Lock Timeouts Internal Rows Inserted Rows Read Rows Written Open Local Cursors Open Local Cursors with Blocking Package Cache Lookups Package Cache Inserts Catalog Cache Lookups Catalog Cache Inserts Catalog Cache Overflows Catalog Cache Heap Full Number of Agents Working on a Statement Stolen Agents Maximum Number of Associated Agents Application Agent Priority Application Priority Type Time Waited for Prefetch Section Lookups Section Inserts Current Agents Waiting On Locks Total Hash Joins Total Hash Loops Hash Join Overflows Hash Join Small Overflows Application Idle Time Unit of Work Log Space Used Total Time Unit of Work Waited on Locks Unit of Work Completion Status User CPU Time used by Agent System CPU Time used by Agent Connection Request Start Timestamp Connection Request Completion Timestamp Last Reset Timestamp Unit of Work Start Timestamp Unit of Work Stop Timestamp Previous Unit of Work Completion Timestamp Most Recent Unit of Work Elapsed Time
stmt	num_agents agents_top stmt_type stmt_operation section_number query_cost_estimate query_card_estimate degree_parallelism stmt_sorts total_sort_time sort_overflows rows_read rows_written int_rows_deleted int_rows_updated int_rows_inserted fetch_count stmt_start stmt_stop stmt_usr_cpu_time stmt_sys_cpu_time stmt_elapsed_time stmt_node_number cursor_name creator package_name stmt_text	Number of Agents Working on a Statement Number of Agents Created Statement Type Statement Operation Section Number Query Cost Estimate Query Number of Rows Estimate Degree of Parallelism Statement Sorts Total Sort Time Sort Overflows Rows Read Rows Written Internal Rows Deleted Internal Rows Updated Internal Rows Inserted Number of Successful Fetches Statement Operation Start Timestamp Statement Operation Stop Timestamp User CPU Time used by Statement System CPU Time used by Statement Most Recent Statement Elapsed Time Statement Node Cursor Name Application Creator Package Name SQL Dynamic Statement Text
subsection	ss_exec_time tq_tot_send_spills tq_cur_send_spills tq_max_send_spills tq_rows_read tq_rows_written rows_read rows_written ss_usr_cpu_time ss_sys_cpu_time ss_number ss_status ss_node_number tq_node_waited_for tq_wait_for_any tq_id_waiting_on	Execution Elapsed Time Total Number of Tablequeue Buffers Overflowed Current Number of Tablequeue Buffers Overflowed Maximum Number of Tablequeue Buffers Overflows Number of Rows Read from Tablequeues Number of Rows Written to Tablequeues Rows Read Rows Written User CPU Time used by Subsection System CPU Time used by Subsection Subsection Number Subsection Status Subsection Node Number Waited for Node on a Tablequeue Waiting for Any Node to Send on a Tablequeue Waited on Node on a Tablequeue
agent	agent_pid	Process or Thread ID
dcs_dbase	sql_stmts failed_sql_stmts commit_sql_stmts rollback_sql_stmts rows_selected gw_total_cons gw_cur_cons gw_cons_wait_host gw_cons_wait_client gw_connections_top gw_comm_errors gw_con_time outbound_bytes_sent outbound_bytes_received gw_con_time last_reset gw_comm_error_time con_response_time con_elapsed_time host_response_time dcs_db_name host_db_name	Number of SQL Statements Attempted Failed Statement Operations Commit Statements Attempted Rollback Statements Attempted Rows Selected Total Number of Attempted Connections for DB2 Connect Current Number of Connections for DB2 Connect Number of Connections Waiting for the Host to Reply "Number of Connections Waiting for the Client to Send Request" Maximum Number of Concurrent Connections Communication Errors DB2 Connect Gateway First Connect Initiated Outbound Number of Bytes Sent Inbound Number of Bytes Received DB2 Connect Gateway First Connect Initiated Last Reset Timestamp Communication Error Time Most Recent Response Time for Connect Most Recent Connection Elapsed Time Host Response Time DCS Database Name Host Database Name
dcs_appl_info	agent_id codepage_id dcs_appl_status client_pid status_change_time client_platform client_protocol host_ccsid outbound_comm_protocol execution_id appl_name appl_id sequence_no auth_id client_nname client_prdid gw_db_alias dcs_db_name host_db_name host_prdid outbound_appl_id outbound_sequence_no outbound_comm_address inbound_comm_address	Application Handle (agent ID) ID of Code Page Used by Application DCS Application Status Client Process ID Application Status Change Time Client Operating Platform Client Communication Protocol Host Coded Character Set ID Outbound Communication Protocol User Login ID Application Name Application ID Sequence Number Authorization ID Configuration NNAME of Client Client Product/Version ID Database Alias at the Gateway DCS Database Name Host Database Name Host Product/Version ID Outbound Application ID Outbound Sequence Number Outbound Communication Address Inbound Communication Address
dcs_appl	open_cursors appl_idle_time uow_comp_status sql_stmts failed_sql_stmts commit_sql_stmts rollback_sql_stmts rows_selected inbound_bytes_received outbound_bytes_sent outbound_bytes_received inbound_bytes_sent prev_uow_stop_time uow_start_time uow_stop_time last_reset gw_con_time gw_exec_time host_response_time uow_elapsed_time xid tpmon_client_userid tpmon_client_wkstn tpmon_client_app tpmon_acc_str	Number of Open Cursors Application Idle Time Unit of Work Completion Status Number of SQL Statements Attempted Failed Statement Operations Commit Statements Attempted Rollback Statements Attempted Rows Selected Inbound Number of Bytes Received Outbound Number of Bytes Sent Outbound Number of Bytes Received Inbound Number of Bytes Sent Previous Unit of Work Completion Timestamp Unit of Work Start Timestamp Unit of Work Stop Timestamp Last Reset Timestamp DB2 Connect Gateway First Connect Initiated Elapsed Time Spent on DB2 Connect Gateway Processing Host Response Time Most Recent Unit of Work Elapsed Time Transaction ID TP Monitor Client User ID TP Monitor Client Workstation Name TP Monitor Client Application Name TP Monitor Client Accounting String
dcs_stmt	section_number query_cost_estimate query_card_estimate stmt_operation fetch_count inbound_bytes_received outbound_bytes_sent outbound_bytes_received inbound_bytes_sent stmt_start stmt_stop gw_exec_time host_response_time stmt_elpased_time creator package_name stmt_text	Section Number Query Cost Estimate Query Number of Rows Estimate Statement Operation Number of Successful Fetches Inbound Number of Bytes Received Outbound Number of Bytes Sent Outbound Number of Bytes Received Inbound Number of Bytes Sent Statement Operation Start Timestamp Statement Operation Stop Timestamp Elapsed Time Spent on DB2 Connect Gateway Processing Host Response Time Most Recent Statement Elapsed Time Application Creator Package Name SQL Dynamic Statement Text

Table 6. Event Monitor Logical Data Groups and Data Elements

Event Logical Data Groups	Data Elements	See page
db_event	lock_waits lock_wait_time deadlocks lock_escals lock_escals lock_timeouts total_sorts total_sort_time sort_overflows 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 pool_lsn_gap_clns pool_drty_pg_steal_clns pool_drty_pg_thrsh_clns direct_reads direct_writes direct_read_reqs direct_write_reqs direct_read_time direct_write_time files_closed 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 rows_deleted rows_inserted rows_updated	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 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 Buffer Pool Log Space Cleaners Triggered Buffer Pool Victim Page Cleaners Triggered Buffer Pool Threshold Cleaners Triggered Direct Reads From Database Direct Writes to Database Direct Read Requests Direct Write Requests Direct Read Time Direct Write Time Database Files Closed 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 Rows Deleted Rows Inserted Rows Updated
db_event (continued)	rows_selected binds_precompiles total_cons connections_top db_heap_top sec_log_used_top tot_log_used_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 pool_async_index_reads pool_data_to_estore pool_index_to_estore pool_index_from_estore pool_data_from_estore 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 talog_node_name partial_record	Rows Selected Binds/Precompiles Attempted Connects Since Database Activation Maximum Number of Concurrent Connections Maximum Database Heap Allocated Maximum Secondary Log Space Used Maximum Total Log Space Used 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 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 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	table_type rows_written rows_read overflow_accesses page_reorgs event_time table_name table_schema partial_record	Table Type Rows Written Rows Read Accesses to Overflowed Records 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 files_closed pool_async_index_reads pool_data_to_estore pool_index_to_estore pool_index_from_estore pool_data_from_estore 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 Database Files Closed 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 Event Time Table Space Name Partial Record
conn_event	lock_waits lock_wait_time lock_escals x_lock_escals deadlocks lock_timeouts total_sorts total_sort_time sort_overflows 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 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 binds_precompiles rej_curs_blk acc_curs_blk pkg_cache_lookups pkg_cache_inserts cat_cache_overflows	Lock Waits Time Waited On Locks Lock Escalation Exclusive Lock Escalations Deadlocks Detected Number of Lock Timeouts Total Sorts Total Sort Time Sort Overflows 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 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 Rows Read Rows Written Binds/Precompiles Attempted Rejected Block Cursor Requests Accepted Block Cursor Requests Package Cache Lookups Package Cache Inserts Catalog Cache Overflows
conn_event (continued)	cat_cache_heap_full appl_section_lookups appl_section_inserts prefetch_wait_time pool_data_to_estore pool_index_to_estore pool_index_from_estore pool_data_from_estore 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	Catalog Cache Heap Full Section Lookups Section Inserts Time Waited for Prefetch 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 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	sqlcode sqlerrml sqlcabc sqlerrmc sqlerrp sqlerrd sqlwarn sqlstate sqlcaid	Administrative API Reference Administrative API Reference Administrative API Reference Administrative API Reference Administrative API Reference Administrative API Reference Administrative API Reference Administrative API Reference Administrative API Reference
stmt_event	stmt_type stmt_operation fetch_count section_number total_sorts total_sort_time sort_overflows rows_read rows_written int_rows_deleted int_rows_updated int_rows_inserted agent_id agents_top start_time stop_time user_cpu_time system_cpu_time sqlca cursor_name creator package_name appl_id sequence_no stmt_text partial_record	Statement Type Statement Operation Number of Successful Fetches Section Number Total Sorts Total Sort Time Sort Overflows Rows Read Rows Written 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 SQL Communications Area (SQLCA) Cursor Name Application Creator Package Name Application ID Sequence Number SQL Dynamic Statement Text Partial Record
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) 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	uow_log_space_used uow_status lock_wait_time locks_held_top lock_escals x_lock_escal rows_written agent_id user_cpu_time system_cpu_time prev_uow_stop_time uow_start_time stop_time appl_id sequence_no partial_record	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 Rows Written Application Handle (agent ID) User CPU Time System CPU Time Previous Unit of Work Completion Timestamp Unit of Work Start Timestamp Event Stop Time 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 files_closed 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 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 Database Files Closed 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 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

[ DB2 List of Books | Search the DB2 Books ]