System Monitor Guide and Reference

Snapshot Monitor Logical Data Groupings

The following table lists the logical data groupings and data elements that can be returned by snapshot monitoring. These correspond to the structures described in Snapshot Requests.

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 smallest_log_avail_node 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 Node with Least Available Log Space 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 node_number	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 Node Number
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_list	db_name db_path	Database Name Database Path
dynsql	rows_read rows_written num_executions num_compilations prep_time_worst prep_time_best int_rows_deleted int_rows_inserted int_rows_updated stmt_sorts total_exec_time tot_s_cpu_time tot_u_cpu_time stmt_text	Rows Read Rows Written Statement Executions Statement Compilations Statement Worst Preparation Time Statement Best Preparation Time Internal Rows Deleted Internal Rows Inserted Internal Rows Updated Statement Sorts Elapsed Statement Execution Time Total System CPU for a Statement Total User CPU for a Statement SQL Dynamic Statement Text
dbase	sec_log_used_top tot_log_used_top total_log_used total_log_available rows_read 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_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 files_closed 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	Maximum Secondary Log Space Used Maximum Total Log Space Used Total Log Space Used Total Log Available Rows Read 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 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 Database Files Closed 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
dbase (continued)	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 total_cons appls_cur_cons appls_in_db2 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	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 Connects Since Database Activation Applications Connected Currently Applications Executing in the Database Currently 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 db_conn_time last_reset last_backup elapsed_exec_time 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 Database Activation Timestamp Last Reset Timestamp Last Backup Timestamp Statement Execution Elapsed Time Database Location Server Operating System Application with Oldest Transaction Catalog Node Network Name Input Database Alias Database Name Database Path
appl_id_info	agent_id appl_status codepage_id status_change_time appl_name appl_id sequence_no auth_id client_nname client_prdid input_db_alias client_db_alias db_name db_path	Application Handle (agent ID) Application Status ID of Code Page Used by Application Application Status Change Time 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
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	rows_written rows_read overflow_accesses table_file_id table_type page_reorgs table_name table_schema	Rows Written Rows Read Accesses to Overflowed Records Table File ID Table Type 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 pool_async_index_reads pool_data_to_estore pool_index_to_estore pool_index_from_estore pool_data_from_estore files_closed 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 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 Table Space Name
db_lock_list	locks_held appls_cur_cons locks_waiting input_db_alias 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 node_number 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 Node Number 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 node_number lock_escalation table_name table_schema tablespace_name	Table File ID Lock Object Type Waited On Lock Mode Lock Status Lock Object Name Node Number 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 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 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 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 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 tpmon_client_userid tpmon_client_wkstn tpmon_client_app tpmon_acc_str	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 TP Monitor Client User ID TP Monitor Client Workstation Name TP Monitor Client Application Name TP Monitor Client Accounting String
appl	uow_log_space_used rows_read rows_written 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 locks_held lock_waits lock_wait_time lock_escals x_lock_escals deadlocks total_sorts total_sort_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_commits int_rollbacks int_deadlock_rollbacks rows_deleted rows_inserted rows_updated	Unit of Work Log Space Used Rows Read Rows Written 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 Locks Held Lock Waits Time Waited On Locks Lock Escalation Exclusive Lock Escalations Deadlocks Detected Total Sorts Total Sort 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 Commits Internal Rollbacks Internal Rollbacks Due To Deadlock Rows Deleted Rows Inserted Rows Updated
appl (continued)	rows_selected binds_precompiles open_rem_curs open_rem_curs_blk rej_curs_blk acc_curs_blk sql_reqs_since_commit lock_timeouts int_rows_inserted 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_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 elapsed_exec_time inbound_comm_address	Rows Selected Binds/Precompiles Attempted Open Remote Cursors Open Remote Cursors with Blocking Rejected Block Cursor Requests Accepted Block Cursor Requests SQL Requests Since Last Commit Number of Lock Timeouts Internal Rows Inserted 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 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 Statement Execution Elapsed Time Inbound Communication Address
stmt	rows_read rows_written 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 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 blocking_cursor stmt_node_number cursor_name creator package_name stmt_text	Rows Read Rows Written 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 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 Blocking Cursor Statement Node Cursor Name Application Creator Package Name SQL Dynamic Statement Text
subsection	rows_read rows_written ss_exec_time tq_tot_send_spills tq_cur_send_spills tq_max_send_spills tq_rows_read tq_rows_written ss_number ss_status ss_node_number tq_node_waited_for tq_wait_for_any tq_id_waiting_on ss_usr_cpu_time ss_sys_cpu_time	Rows Read Rows Written Subsection 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 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 User CPU Time used by Subsection System CPU Time used by Subsection
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 outbound_bytes_sent outbound_bytes_received gw_con_time last_reset gw_comm_error_time con_response_time con_elapsed_time host_response_time elapsed_exec_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 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 Statement Execution Elapsed Time DCS Database Name Host Database Name
dcs_appl_info	agent_id codepage_id dcs_appl_status client_pid agent_status 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 DCS Application Agents 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 elapsed_exec_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 Statement Execution 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 blocking_cursor outbound_blocking_cursor 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 Blocking Cursor Outbound Blocking Cursor Application Creator Package Name SQL Dynamic Statement Text
dbase_remote	total_cons disconnects commit_sql_stmts rollback_sql_stmts select_sql_stmts insert_sql_stmts update_sql_stmts delete_sql_stmts remote_locks create_nickname passthrus stored_procs rows_selected rows_updated rows_deleted rows_inserted sp_rows_selected failed_sql_stmts select_time insert_time update_time remote_lock_time delete_time create_nickname_time passthru_time stored_proc_time datasource_name db_name	Connects Since Database Activation Disconnects Commit Statements Attempted Rollback Statements Attempted Select SQL Statements Executed Inserts Updates Deletes Remote Locks Create Nicknames Pass-Through Stored Procedures Rows Selected Rows Updated Rows Deleted Rows Inserted Rows Returned by Stored Procedures Failed Statement Operations Query Response Time Insert Response Time Update Response Time Remote Lock Time Delete Response Time Create Nickname Response Time Pass-Through Time Stored Procedure Time Data Source Name Database Name
appl_remote	commit_sql_stmts rollback_sql_stmts select_sql_stmts insert_sql_stmts update_sql_stmts delete_sql_stmts remote_locks create_nickname passthrus stored_procs rows_selected rows_updated rows_deleted rows_inserted sp_rows_selected failed_sql_stmts select_time insert_time update_time remote_lock_time delete_time create_nickname_time passthru_time stored_proc_time datasource_name db_name	Commit Statements Attempted Rollback Statements Attempted Select SQL Statements Executed Inserts Updates Deletes Remote Locks Create Nicknames Pass-Through Stored Procedures Rows Selected Rows Updated Rows Deleted Rows Inserted Rows Returned by Stored Procedures Failed Statement Operations Query Response Time Insert Response Time Update Response Time Remote Lock Time Delete Response Time Create Nickname Response Time Pass-Through Time Stored Procedure Time Data Source Name Database Name