Snapshot monitor logical data groups and monitor elements
The following sections list the logical data groupings and monitor elements that can be returned by snapshot monitoring.
- agent logical data group
- appl logical data group
- appl_id_info logical data group
- appl_info logical data group
- appl_lock_list logical data group
- appl_remote logical data group
- bufferpool logical data group
- bufferpool_nodeinfo logical data group
- collected logical data group
- db2 logical data group
- db_lock_list logical data group
- dbase logical data group
- dbase_remote logical data group
- db_storage_group logical data group
- dcs_appl logical data group
- dcs_appl_info logical data group
- dcs_dbase logical data group
- dcs_stmt logical data group
- detail_log logical data group
- dynsql logical data group
- dynsql_list logical data group
- fcm logical data group
- fcm_node logical data group
- hadr logical data group
- lock logical data group
- lock_wait logical data group
- memory_pool logical data group
- progress logical data group
- progress_list logical data group
- rollforward logical data group
- stmt logical data group
- stmt_transmissions logical data group
- subsection logical data group
- table logical data group
- table_list logical data group
- table_reorg logical data group
- tablespace logical data group
- tablespace_container logical data group
- tablespace_list logical data group
- tablespace_nodeinfo logical data group
- tablespace_quiescer logical data group
- tablespace_range logical data group
- utility_info logical data group
agent logical data group
appl logical data group
- acc_curs_blk - Accepted Block Cursor Requests monitor element
- agent_sys_cpu_time - System CPU Time used by Agent monitor element
- agent_usr_cpu_time - User CPU Time used by Agent monitor element
- agents_stolen - Stolen Agents monitor element
- appl_con_time - Connection Request Start Timestamp monitor element
- appl_idle_time - Application Idle Time monitor element
- appl_priority - Application Agent Priority monitor element
- appl_priority_type - Application Priority Type monitor element
- associated_agents_top - Maximum Number of Associated Agents monitor element
- authority_bitmap - User authorization level monitor element
- authority_lvl - User authorization level monitor element
- binds_precompiles - Binds/Precompiles Attempted monitor element
- cat_cache_inserts - Catalog cache inserts monitor element
- cat_cache_lookups - Catalog cache lookups monitor element
- cat_cache_overflows - Catalog Cache Overflows monitor element
- commit_sql_stmts - Commit Statements Attempted monitor element
- conn_complete_time - Connection Request Completion Timestamp monitor element
- ddl_sql_stmts - Data Definition Language (DDL) SQL Statements monitor element
- deadlocks - Deadlocks detected monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor element
- failed_sql_stmts - Failed Statement Operations monitor element
- hash_join_overflows - Hash Join Overflows monitor element
- hash_join_small_overflows - Hash Join Small Overflows monitor element
- inbound_comm_address - Inbound Communication Address monitor element
- int_auto_rebinds - Internal Automatic Rebinds monitor element
- int_commits - Internal commits monitor element
- int_deadlock_rollbacks - Internal Rollbacks Due To Deadlock monitor element
- int_rollbacks - Internal rollbacks monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- last_reset - Last Reset Timestamp monitor element
- lock_escalation - Lock escalation monitor element
- lock_timeout_val - Lock timeout value monitor element
- lock_timeouts - Number of lock timeouts monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_waits - Lock waits monitor element
- locks_held - Locks held monitor element
- locks_waiting - Current agents waiting on locks monitor element
- num_agents - Number of Agents Working on a Statement monitor element
- olap_func_overflows - OLAP Function Overflows monitor element
- open_loc_curs - Open Local Cursors monitor element
- open_loc_curs_blk - Open Local Cursors with Blocking monitor element
- open_rem_curs - Open Remote Cursors monitor element
- open_rem_curs_blk - Open Remote Cursors with Blocking monitor element
- pkg_cache_inserts - Package cache inserts monitor element
- pkg_cache_lookups - Package cache lookups monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- prefetch_wait_time - Time waited for prefetch monitor element
- prev_uow_stop_time - Previous Unit of Work Completion Timestamp monitor element
- rej_curs_blk - Rejected Block Cursor Requests monitor element
- rollback_sql_stmts - Rollback Statements Attempted monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_read - Rows read monitor element
- rows_selected - Rows Selected monitor element
- rows_updated - Rows updated monitor element
- rows_written - Rows Written monitor element
- select_sql_stmts - Select SQL Statements Executed monitor element
- sort_overflows - Sort overflows monitor element
- sql_reqs_since_commit - SQL Requests Since Last Commit monitor element
- static_sql_stmts - Static SQL Statements Attempted monitor element
- total_hash_joins - Total Hash Joins monitor element
- total_hash_loops - Total Hash Loops monitor element
- total_olap_funcs - Total OLAP Functions monitor element
- total_sort_time - Total sort time monitor element
- total_sorts - Total sorts monitor element
- uid_sql_stmts - Update/Insert/Merge/Delete SQL Statements Executed monitor element
- unread_prefetch_pages - Unread prefetch pages monitor element
- uow_comp_status - Unit of Work Completion Status monitor element
- uow_elapsed_time - Most Recent Unit of Work Elapsed Time monitor element
- uow_lock_wait_time - Total time unit of work waited on locks monitor element
- uow_log_space_used - Unit of work log space used monitor element
- uow_start_time - Unit of work start timestamp monitor element
- uow_stop_time - Unit of work stop timestamp monitor element
- x_lock_escals - Exclusive lock escalations monitor element
- xquery_stmts - XQuery Statements Attempted monitor element
appl_id_info logical data group
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- appl_name - Application name monitor element
- appl_status - Application status monitor element
- auth_id - Authorization ID monitor element
- client_db_alias - Database Alias Used by Application monitor element
- client_prdid - Client product and version ID monitor element
- codepage_id - ID of Code Page Used by Application monitor element
- db_name - Database name monitor element
- db_path - Database Path monitor element
- input_db_alias - Input Database Alias monitor element
- sequence_no - Sequence number monitor element
- status_change_time - Application Status Change Time monitor element
appl_info logical data group
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- appl_name - Application name monitor element
- appl_section_inserts - Section Inserts monitor element
- appl_section_lookups - Section Lookups monitor element
- appl_status - Application status monitor element
- auth_id - Authorization ID monitor element
- authority_bitmap - User authorization level monitor element
- authority_lvl - User authorization level monitor element
- client_db_alias - Database Alias Used by Application monitor element
- client_pid - Client process ID monitor element
- client_platform - Client operating platform monitor element
- client_prdid - Client product and version ID monitor element
- client_protocol - Client communication protocol monitor element
- codepage_id - ID of Code Page Used by Application monitor element
- coord_agent_pid - Coordinator agent identifier monitor element
- coord_node - Coordinating Node monitor element
- corr_token - DRDA Correlation Token monitor element
- db_name - Database name monitor element
- db_path - Database Path monitor element
- execution_id - User Login ID monitor element
- input_db_alias - Input Database Alias monitor element
- is_system_appl - Is System Application monitor element
- num_assoc_agents - Number of Associated Agents monitor element
- sequence_no - Sequence number monitor element
- session_auth_id - Session authorization ID monitor element
- status_change_time - Application Status Change Time monitor element
- territory_code - Database Territory Code monitor element
- tpmon_acc_str - TP monitor client accounting string monitor element
- tpmon_client_app - TP monitor client application name monitor element
- tpmon_client_userid - TP monitor client user ID monitor element
- tpmon_client_wkstn - TP monitor client workstation name monitor element
- workload_id - Workload ID monitor element
appl_lock_list logical data group
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- appl_name - Application name monitor element
- appl_status - Application status monitor element
- auth_id - Authorization ID monitor element
- client_db_alias - Database Alias Used by Application monitor element
- codepage_id - ID of Code Page Used by Application monitor element
- lock_wait_time - Time waited on locks monitor element
- locks_held - Locks held monitor element
- locks_waiting - Current agents waiting on locks monitor element
- sequence_no - Sequence number monitor element
- session_auth_id - Session authorization ID monitor element
- status_change_time - Application Status Change Time monitor element
appl_remote logical data group
- commit_sql_stmts - Commit Statements Attempted monitor element
- create_nickname - Create Nicknames monitor element
- create_nickname_time - Create Nickname Response Time monitor element
- datasource_name - Data Source Name monitor element
- db_name - Database name monitor element
- delete_sql_stmts - Deletes monitor element
- delete_time - Delete Response Time monitor element
- failed_sql_stmts - Failed Statement Operations monitor element
- insert_sql_stmts - Inserts monitor element
- insert_time - Insert Response Time monitor element
- passthru_time - Pass-Through Time monitor element
- passthrus - Pass-Through monitor element
- remote_lock_time - Remote Lock Time monitor element
- remote_locks - Remote Locks monitor element
- rollback_sql_stmts - Rollback Statements Attempted monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_selected - Rows Selected monitor element
- rows_updated - Rows updated monitor element
- select_sql_stmts - Select SQL Statements Executed monitor element
- select_time - Query Response Time monitor element
- sp_rows_selected - Rows Returned by Stored Procedures monitor element
- stored_proc_time - Stored Procedure Time monitor element
- stored_procs - Stored Procedures monitor element
- update_sql_stmts - Updates monitor element
- update_time - Update Response Time monitor element
bufferpool logical data group
- block_ios - Number of block I/O requests monitor element
- bp_id - Buffer pool identifier monitor element
- bp_name - Buffer pool name monitor element
- db_name - Database name monitor element
- db_path - Database Path monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- files_closed - Database files closed monitor element
- input_db_alias - Input Database Alias monitor element
- pages_from_block_ios - Total number of pages read by block I/O monitor element
- pages_from_vectored_ios - Total number of pages read by vectored I/O monitor element
- pool_async_data_read_reqs - Buffer pool asynchronous read requests monitor element
- pool_async_data_reads - Buffer pool asynchronous data reads monitor element
- pool_async_data_writes - Buffer pool asynchronous data writes monitor element
- pool_async_index_read_reqs - Buffer pool asynchronous index read requests monitor element
- pool_async_index_reads - Buffer pool asynchronous index reads monitor element
- pool_async_index_writes - Buffer pool asynchronous index writes monitor element
- pool_async_read_time - Buffer Pool Asynchronous Read Time monitor element
- pool_async_write_time - Buffer pool asynchronous write time monitor element
- pool_async_xda_read_reqs - Buffer pool asynchronous XDA read requests monitor element
- pool_async_xda_reads - Buffer pool asynchronous XDA data reads monitor element
- pool_async_xda_writes - Buffer pool asynchronous XDA data writes monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_no_victim_buffer - Buffer pool no victim buffers monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- vectored_ios - Number of vectored I/O requests monitor element
bufferpool_nodeinfo logical data group
- bp_cur_buffsz - Current Size of Buffer Pool monitor element
- bp_new_buffsz - New Buffer Pool Size monitor element
- bp_pages_left_to_remove - Number of Pages Left to Remove monitor element
- bp_tbsp_use_count - Number of Table Spaces Mapped to Buffer Pool monitor element
- node_number - Node Number monitor element
collected logical data group
- node_number - Node Number monitor element
- server_db2_type - Database Manager Type at Monitored (Server) Node monitor element
- server_instance_name - Server Instance Name monitor element
- server_prdid - Server Product/Version ID monitor element
- server_version - Server Version monitor element
- time_stamp - Snapshot Time monitor element
- time_zone_disp - Time Zone Displacement monitor element
db2 logical data group
- agents_created_empty_pool - Agents Created Due to Empty Agent Pool monitor element
- agents_from_pool - Agents Assigned From Pool monitor element
- agents_registered - Agents Registered monitor element
- agents_registered_top - Maximum Number of Agents Registered monitor element
- agents_stolen - Stolen Agents monitor element
- agents_waiting_on_token - Agents Waiting for a Token monitor element
- agents_waiting_top - Maximum Number of Agents Waiting monitor element
- comm_private_mem - Committed Private Memory monitor element
- con_local_dbases - Local Databases with Current Connects monitor element
- coord_agents_top - Maximum Number of Coordinating Agents monitor element
- db2start_time - Start Database Manager Timestamp monitor element
- db_status - Status of database monitor element
- gw_cons_wait_client - Number of Connections Waiting for the Client to Send Request monitor element
- gw_cons_wait_host - Number of Connections Waiting for the Host to Reply monitor element
- gw_cur_cons - Current Number of Connections for Db2 Connect monitor element
- gw_total_cons - Total Number of Attempted Connections for Db2 Connect monitor element
- idle_agents - Number of Idle Agents monitor element
- last_reset - Last Reset Timestamp monitor element
- local_cons - Local Connections monitor element
- local_cons_in_exec - Local Connections Executing in the Database Manager monitor element
- max_agent_overflows - Maximum Agent Overflows monitor element
- num_gw_conn_switches - Connection Switches monitor element
- num_nodes_in_db2_instance - Number of Nodes in Partition monitor element
- piped_sorts_accepted - Piped Sorts Accepted monitor element
- piped_sorts_requested - Piped Sorts Requested monitor element
- post_threshold_hash_joins - Hash Join Threshold monitor element
- post_threshold_olap_funcs - OLAP Function Threshold monitor element
- post_threshold_sorts - Post threshold sorts monitor element
- product_name - Product Name monitor element
- rem_cons_in - Remote Connections To Database Manager monitor element
- rem_cons_in_exec - Remote Connections Executing in the Database Manager monitor element
- service_level - Service Level monitor element
- smallest_log_avail_node - Node with Least Available Log Space monitor element
- sort_heap_allocated - Total Sort Heap Allocated monitor element
- sort_heap_top - Sort private heap high watermark monitor element
db_lock_list logical data group
- appls_cur_cons - Applications Connected Currently monitor element
- db_name - Database name monitor element
- db_path - Database Path monitor element
- input_db_alias - Input Database Alias monitor element
- locks_held - Locks held monitor element
- locks_waiting - Current agents waiting on locks monitor element
dbase logical data group
- active_hash_joins - Active hash joins monitor element
- active_olap_funcs - Active OLAP Functions monitor element
- active_sorts - Active Sorts monitor element
- agents_top - Number of Agents Created monitor element
- appl_id_oldest_xact - Application with Oldest Transaction monitor element
- appl_section_inserts - Section Inserts monitor element
- appl_section_lookups - Section Lookups monitor element
- appls_cur_cons - Applications Connected Currently monitor element
- appls_in_db2 - Applications Executing in the Database Currently monitor element
- async_runstats - Total number of asynchronous RUNSTATS requests monitor element
- binds_precompiles - Binds/Precompiles Attempted monitor element
- blocks_pending_cleanup - Pending cleanup rolled-out blocks monitor element
- cat_cache_inserts - Catalog cache inserts monitor element
- cat_cache_lookups - Catalog cache lookups monitor element
- cat_cache_overflows - Catalog Cache Overflows monitor element
- cat_cache_size_top - Catalog cache high watermark monitor element
- catalog_node - Catalog Node Number monitor element
- catalog_node_name - Catalog Node Network Name monitor element
- commit_sql_stmts - Commit Statements Attempted monitor element
- connections_top - Maximum Number of Concurrent Connections monitor element
- coord_agents_top - Maximum Number of Coordinating Agents monitor element
- db_conn_time - Database activation timestamp monitor element
- db_heap_top - Maximum Database Heap Allocated monitor element
- db_location - Database Location monitor element
- db_name - Database name monitor element
- db_path - Database Path monitor element
- db_status - Status of database monitor element
- ddl_sql_stmts - Data Definition Language (DDL) SQL Statements monitor element
- deadlocks - Deadlocks detected monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor element
- failed_sql_stmts - Failed Statement Operations monitor element
- files_closed - Database files closed monitor element
- hash_join_overflows - Hash Join Overflows monitor element
- hash_join_small_overflows - Hash Join Small Overflows monitor element
- input_db_alias - Input Database Alias monitor element
- int_auto_rebinds - Internal Automatic Rebinds monitor element
- int_commits - Internal commits monitor element
- int_deadlock_rollbacks - Internal Rollbacks Due To Deadlock monitor element
- int_rollbacks - Internal rollbacks monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- last_backup - Last Backup Timestamp monitor element
- last_reset - Last Reset Timestamp monitor element
- lock_escals - Number of lock escalations monitor element
- lock_list_in_use - Total lock list memory in use monitor element
- lock_timeouts - Number of lock timeouts monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_waits - Lock waits monitor element
- locks_held - Locks held monitor element
- locks_waiting - Current agents waiting on locks monitor element
- log_held_by_dirty_pages - Amount of Log Space Accounted for by Dirty Pages monitor element
- log_read_time - Log Read Time monitor element
- log_reads - Number of Log Pages Read monitor element
- log_to_redo_for_recovery - Amount of Log to be Redone for Recovery monitor element
- log_write_time - Log Write Time monitor element
- log_writes - Number of Log Pages Written monitor element
- num_assoc_agents - Number of Associated Agents monitor element
- num_db_storage_paths - Number of automatic storage paths monitor element
- num_indoubt_trans - Number of Indoubt Transactions monitor element
- num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
- num_log_data_found_in_buffer - Number of Log Data Found In Buffer monitor element
- num_log_part_page_io - Number of Partial Log Page Writes monitor element
- num_log_read_io - Number of Log Reads monitor element
- num_log_write_io - Number of Log Writes monitor element
- olap_func_overflows - OLAP Function Overflows monitor element
- pkg_cache_inserts - Package cache inserts monitor element
- pkg_cache_lookups - Package cache lookups monitor element
- pkg_cache_num_overflows - Package Cache Overflows monitor element
- pkg_cache_size_top - Package cache high watermark monitor element
- pool_async_data_read_reqs - Buffer pool asynchronous read requests monitor element
- pool_async_data_reads - Buffer pool asynchronous data reads monitor element
- pool_async_data_writes - Buffer pool asynchronous data writes monitor element
- pool_async_index_read_reqs - Buffer pool asynchronous index read requests monitor element
- pool_async_index_reads - Buffer pool asynchronous index reads monitor element
- pool_async_index_writes - Buffer pool asynchronous index writes monitor element
- pool_async_read_time - Buffer Pool Asynchronous Read Time monitor element
- pool_async_write_time - Buffer pool asynchronous write time monitor element
- pool_async_xda_read_reqs - Buffer pool asynchronous XDA read requests monitor element
- pool_async_xda_reads - Buffer pool asynchronous XDA data reads monitor element
- pool_async_xda_writes - Buffer pool asynchronous XDA data writes monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_drty_pg_steal_clns - Buffer pool victim page cleaners triggered monitor element
- pool_drty_pg_thrsh_clns - Buffer pool threshold cleaners triggered monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_lsn_gap_clns - Buffer pool log space cleaners triggered monitor element
- pool_no_victim_buffer - Buffer pool no victim buffers monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- post_shrthreshold_hash_joins - Post threshold hash joins monitor element
- post_shrthreshold_sorts - Post shared threshold sorts monitor element
- rollback_sql_stmts - Rollback Statements Attempted monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_read - Rows read monitor element
- rows_selected - Rows Selected monitor element
- rows_updated - Rows updated monitor element
- sec_log_used_top - Maximum Secondary Log Space Used monitor element
- sec_logs_allocated - Secondary Logs Allocated Currently monitor element
- select_sql_stmts - Select SQL Statements Executed monitor element
- server_platform - Server Operating System monitor element
- sort_heap_allocated - Total Sort Heap Allocated monitor element
- sort_overflows - Sort overflows monitor element
- sort_shrheap_allocated - Sort Share Heap Currently Allocated monitor element
- sort_shrheap_top - Sort share heap high watermark monitor element
- static_sql_stmts - Static SQL Statements Attempted monitor element
- stats_cache_size - Size of statistics cache monitor element
- stats_fabricate_time - Total time spent on statistics fabrication activities monitor element
- stats_fabrications - Total number of statistics fabrications monitor elements
- sync_runstats - Total number of synchronous RUNSTATS activities monitor element
- sync_runstats_time - Total time spent on synchronous RUNSTATS activities monitor element
- tot_log_used_top - Maximum Total Log Space Used monitor element
- total_cons - Connects Since Database Activation monitor element
- total_hash_joins - Total Hash Joins monitor element
- total_hash_loops - Total Hash Loops monitor element
- total_log_available - Total Log Available monitor element
- total_log_used - Total Log Space Used monitor element
- total_olap_funcs - Total OLAP Functions monitor element
- total_sec_cons - Secondary Connections monitor element
- total_sort_time - Total sort time monitor element
- total_sorts - Total sorts monitor element
- uid_sql_stmts - Update/Insert/Merge/Delete SQL Statements Executed monitor element
- unread_prefetch_pages - Unread prefetch pages monitor element
- x_lock_escals - Exclusive lock escalations monitor element
- xquery_stmts - XQuery Statements Attempted monitor element
dbase_remote logical data group
- commit_sql_stmts - Commit Statements Attempted monitor element
- create_nickname - Create Nicknames monitor element
- create_nickname_time - Create Nickname Response Time monitor element
- datasource_name - Data Source Name monitor element
- db_name - Database name monitor element
- delete_sql_stmts - Deletes monitor element
- delete_time - Delete Response Time monitor element
- disconnects - Disconnects monitor element
- failed_sql_stmts - Failed Statement Operations monitor element
- insert_sql_stmts - Inserts monitor element
- insert_time - Insert Response Time monitor element
- passthru_time - Pass-Through Time monitor element
- passthrus - Pass-Through monitor element
- remote_lock_time - Remote Lock Time monitor element
- remote_locks - Remote Locks monitor element
- rollback_sql_stmts - Rollback Statements Attempted monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_selected - Rows Selected monitor element
- rows_updated - Rows updated monitor element
- select_sql_stmts - Select SQL Statements Executed monitor element
- select_time - Query Response Time monitor element
- sp_rows_selected - Rows Returned by Stored Procedures monitor element
- stored_proc_time - Stored Procedure Time monitor element
- stored_procs - Stored Procedures monitor element
- total_cons - Connects Since Database Activation monitor element
- update_sql_stmts - Updates monitor element
- update_time - Update Response Time monitor element
db_storage_group logical data group
- fs_id - Unique file system identification number monitor element
- fs_total_size - Total size of a file system monitor element
- fs_used_size - Amount of space used on a file system monitor element
- node_number - Node Number monitor element
- sto_path_free_size - Automatic storage path free space monitor element
dcs_appl logical data group
- appl_idle_time - Application Idle Time monitor element
- commit_sql_stmts - Commit Statements Attempted monitor element
- elapsed_exec_time - Statement Execution Elapsed Time monitor element
- failed_sql_stmts - Failed Statement Operations monitor element
- gw_con_time - Db2 Connect Gateway First Connect Initiated monitor element
- gw_exec_time - Elapsed Time Spent on Db2 Connect Gateway Processing monitor element
- host_response_time - Host Response Time monitor element
- inbound_bytes_received - Inbound Number of Bytes Received monitor element
- inbound_bytes_sent - Inbound Number of Bytes Sent monitor element
- last_reset - Last Reset Timestamp monitor element
- max_data_received_1024 - Number of Statements with Outbound Bytes Received Between 513 and 1024 Bytes monitor element
- max_data_received_128 - Number of Statements with Outbound Bytes Received Between 1 and 128 Bytes monitor element
- max_data_received_16384 - Number of Statements with Outbound Bytes Received Between 8193 and 16384 Bytes monitor element
- max_data_received_2048 - Number of Statements with Outbound Bytes Received Between 1025 and 2048 Bytes monitor element
- max_data_received_256 - Number of Statements with Outbound Bytes Received Between 129 and 256 Bytes monitor element
- max_data_received_31999 - Number of Statements with Outbound Bytes Received Between 16385 and 31999 Bytes monitor element
- max_data_received_4096 - Number of Statements with Outbound Bytes Received Between 2049 and 4096 Bytes monitor element
- max_data_received_512 - Number of Statements with Outbound Bytes Received Between 257 and 512 Bytes monitor element
- max_data_received_64000 - Number of Statements with Outbound Bytes Received Between 32000 and 64000 Bytes monitor element
- max_data_received_8192 - Number of Statements with Outbound Bytes Received Between 4097 and 8192 Bytes monitor element
- max_data_received_gt64000 - Number of Statements with Outbound Bytes Received Greater than 64000 Bytes monitor element
- max_data_sent_1024 - Number of Statements with Outbound Bytes Sent Between 513 and 1024 Bytes monitor element
- max_data_sent_128 - Number of Statements with Outbound Bytes Sent Between 1 and 128 Bytes monitor element
- max_data_sent_16384 - Number of Statements with Outbound Bytes Sent Between 8193 and 16384 Bytes monitor element
- max_data_sent_2048 - Number of Statements with Outbound Bytes Sent Between 1025 and 2048 Bytes monitor element
- max_data_sent_256 - Number of Statements with Outbound Bytes Sent Between 129 and 256 Bytes monitor element
- max_data_sent_31999 - Number of Statements with Outbound Bytes Sent Between 16385 and 31999 Bytes monitor element
- max_data_sent_4096 - Number of Statements with Outbound Bytes Sent Between 2049 and 4096 Bytes monitor element
- max_data_sent_512 - Number of Statements with Outbound Bytes Sent Between 257 and 512 Bytes monitor element
- max_data_sent_64000 - Number of Statements with Outbound Bytes Sent Between 32000 and 64000 Bytes monitor element
- max_data_sent_8192 - Number of Statements with Outbound Bytes Sent Between 4097 and 8192 Bytes monitor element
- max_data_sent_gt64000 - Number of Statements with Outbound Bytes Sent Greater than 64000 Bytes monitor element
- max_network_time_100_ms - Number of Statements with Network Time between 16 and 100 ms monitor element
- max_network_time_16_ms - Number of Statements with Network Time between 4 and 16 ms monitor element
- max_network_time_1_ms - Number of Statements with Network Time of up to 1 ms monitor element
- max_network_time_4_ms - Number of Statements with Network Time between 1 and 4 ms monitor element
- max_network_time_500_ms - Number of Statements with Network Time between 100 and 500 ms monitor element
- max_network_time_gt500_ms - Number of Statements with Network Time greater than 500 ms monitor element
- network_time_bottom - Minimum Network Time for Statement monitor element
- network_time_top - Maximum Network Time for Statement monitor element
- open_cursors - Number of Open Cursors monitor element
- outbound_bytes_received - Outbound Number of Bytes Received monitor element
- outbound_bytes_sent - Outbound Number of Bytes Sent monitor element
- prev_uow_stop_time - Previous Unit of Work Completion Timestamp monitor element
- rollback_sql_stmts - Rollback Statements Attempted monitor element
- rows_selected - Rows Selected monitor element
- sql_stmts - Number of SQL Statements Attempted monitor element
- tpmon_acc_str - TP monitor client accounting string monitor element
- tpmon_client_app - TP monitor client application name monitor element
- tpmon_client_userid - TP monitor client user ID monitor element
- tpmon_client_wkstn - TP monitor client workstation name monitor element
- uow_comp_status - Unit of Work Completion Status monitor element
- uow_elapsed_time - Most Recent Unit of Work Elapsed Time monitor element
- uow_start_time - Unit of work start timestamp monitor element
- uow_stop_time - Unit of work stop timestamp monitor element
- xid - Transaction ID monitor element
dcs_appl_info logical data group
- agent_id - Application handle (agent ID) monitor element
- agent_status - DCS Application Agents monitor element
- appl_id - Application ID monitor element
- appl_name - Application name monitor element
- auth_id - Authorization ID monitor element
- client_pid - Client process ID monitor element
- client_platform - Client operating platform monitor element
- client_prdid - Client product and version ID monitor element
- client_protocol - Client communication protocol monitor element
- codepage_id - ID of Code Page Used by Application monitor element
- dcs_appl_status - DCS application status monitor element
- dcs_db_name - DCS Database Name monitor element
- execution_id - User Login ID monitor element
- gw_db_alias - Database Alias at the Gateway monitor element
- host_ccsid - Host Coded Character Set ID monitor element
- host_db_name - Host Database Name monitor element
- host_prdid - Host Product/Version ID monitor element
- inbound_comm_address - Inbound Communication Address monitor element
- outbound_appl_id - Outbound Application ID monitor element
- outbound_comm_address - Outbound Communication Address monitor element
- outbound_comm_protocol - Outbound Communication Protocol monitor element
- outbound_sequence_no - Outbound Sequence Number monitor element
- sequence_no - Sequence number monitor element
- status_change_time - Application Status Change Time monitor element
dcs_dbase logical data group
- commit_sql_stmts - Commit Statements Attempted monitor element
- con_elapsed_time - Most Recent Connection Elapsed Time monitor element
- con_response_time - Most Recent Response Time for Connect monitor element
- dcs_db_name - DCS Database Name monitor element
- elapsed_exec_time - Statement Execution Elapsed Time monitor element
- failed_sql_stmts - Failed Statement Operations monitor element
- gw_comm_error_time - Communication Error Time monitor element
- gw_comm_errors - Communication Errors monitor element
- gw_con_time - Db2 Connect Gateway First Connect Initiated monitor element
- gw_connections_top - Maximum Number of Concurrent Connections to Host Database monitor element
- gw_cons_wait_client - Number of Connections Waiting for the Client to Send Request monitor element
- gw_cons_wait_host - Number of Connections Waiting for the Host to Reply monitor element
- gw_cur_cons - Current Number of Connections for Db2 Connect monitor element
- gw_total_cons - Total Number of Attempted Connections for Db2 Connect monitor element
- host_db_name - Host Database Name monitor element
- host_response_time - Host Response Time monitor element
- inbound_bytes_received - Inbound Number of Bytes Received monitor element
- last_reset - Last Reset Timestamp monitor element
- max_data_received_1024 - Number of Statements with Outbound Bytes Received Between 513 and 1024 Bytes monitor element
- max_data_received_128 - Number of Statements with Outbound Bytes Received Between 1 and 128 Bytes monitor element
- max_data_received_16384 - Number of Statements with Outbound Bytes Received Between 8193 and 16384 Bytes monitor element
- max_data_received_2048 - Number of Statements with Outbound Bytes Received Between 1025 and 2048 Bytes monitor element
- max_data_received_256 - Number of Statements with Outbound Bytes Received Between 129 and 256 Bytes monitor element
- max_data_received_31999 - Number of Statements with Outbound Bytes Received Between 16385 and 31999 Bytes monitor element
- max_data_received_4096 - Number of Statements with Outbound Bytes Received Between 2049 and 4096 Bytes monitor element
- max_data_received_512 - Number of Statements with Outbound Bytes Received Between 257 and 512 Bytes monitor element
- max_data_received_64000 - Number of Statements with Outbound Bytes Received Between 32000 and 64000 Bytes monitor element
- max_data_received_8192 - Number of Statements with Outbound Bytes Received Between 4097 and 8192 Bytes monitor element
- max_data_received_gt64000 - Number of Statements with Outbound Bytes Received Greater than 64000 Bytes monitor element
- max_data_sent_1024 - Number of Statements with Outbound Bytes Sent Between 513 and 1024 Bytes monitor element
- max_data_sent_128 - Number of Statements with Outbound Bytes Sent Between 1 and 128 Bytes monitor element
- max_data_sent_16384 - Number of Statements with Outbound Bytes Sent Between 8193 and 16384 Bytes monitor element
- max_data_sent_2048 - Number of Statements with Outbound Bytes Sent Between 1025 and 2048 Bytes monitor element
- max_data_sent_256 - Number of Statements with Outbound Bytes Sent Between 129 and 256 Bytes monitor element
- max_data_sent_31999 - Number of Statements with Outbound Bytes Sent Between 16385 and 31999 Bytes monitor element
- max_data_sent_4096 - Number of Statements with Outbound Bytes Sent Between 2049 and 4096 Bytes monitor element
- max_data_sent_512 - Number of Statements with Outbound Bytes Sent Between 257 and 512 Bytes monitor element
- max_data_sent_64000 - Number of Statements with Outbound Bytes Sent Between 32000 and 64000 Bytes monitor element
- max_data_sent_8192 - Number of Statements with Outbound Bytes Sent Between 4097 and 8192 Bytes monitor element
- max_data_sent_gt64000 - Number of Statements with Outbound Bytes Sent Greater than 64000 Bytes monitor element
- max_network_time_100_ms - Number of Statements with Network Time between 16 and 100 ms monitor element
- max_network_time_16_ms - Number of Statements with Network Time between 4 and 16 ms monitor element
- max_network_time_1_ms - Number of Statements with Network Time of up to 1 ms monitor element
- max_network_time_4_ms - Number of Statements with Network Time between 1 and 4 ms monitor element
- max_network_time_500_ms - Number of Statements with Network Time between 100 and 500 ms monitor element
- max_network_time_gt500_ms - Number of Statements with Network Time greater than 500 ms monitor element
- network_time_bottom - Minimum Network Time for Statement monitor element
- network_time_top - Maximum Network Time for Statement monitor element
- outbound_bytes_sent - Outbound Number of Bytes Sent monitor element
- rollback_sql_stmts - Rollback Statements Attempted monitor element
- rows_selected - Rows Selected monitor element
- sql_stmts - Number of SQL Statements Attempted monitor element
dcs_stmt logical data group
- blocking_cursor - Blocking Cursor monitor element
- creator - Application Creator monitor element
- elapsed_exec_time - Statement Execution Elapsed Time monitor element
- fetch_count - Number of Successful Fetches monitor element
- gw_exec_time - Elapsed Time Spent on Db2 Connect Gateway Processing monitor element
- host_response_time - Host Response Time monitor element
- inbound_bytes_received - Inbound Number of Bytes Received monitor element
- inbound_bytes_sent - Inbound Number of Bytes Sent monitor element
- num_transmissions - Number of Transmissions monitor element
- num_transmissions_group - Number of Transmissions Group monitor element
- outbound_bytes_received - Outbound Number of Bytes Received monitor element
- outbound_bytes_sent - Outbound Number of Bytes Sent monitor element
- package_name - Package name monitor element
- query_card_estimate - Query Number of Rows Estimate monitor element
- query_cost_estimate - Query cost estimate monitor element
- section_number - Section number monitor element
- stmt_elapsed_time - Most Recent Statement Elapsed Time monitor element
- stmt_operation/operation - Statement operation monitor element
- stmt_start - Statement Operation Start Timestamp monitor element
- stmt_stop - Statement Operation Stop Timestamp monitor element
- stmt_text - SQL statement text monitor element
detail_log logical data group
- current_active_log - Current Active Log File Number monitor element
- current_archive_log - Current Archive Log File Number monitor element
- first_active_log - First Active Log File Number monitor element
- last_active_log - Last Active Log File Number monitor element
- node_number - Node Number monitor element
dynsql logical data group
- fetch_count - Number of Successful Fetches monitor element
- insert_timestamp - Insert timestamp monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- num_compilations - Statement Compilations monitor element
- num_executions - Statement executions monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- prep_time_best - Statement best preparation time monitor element
- prep_time_worst - Statement worst preparation time monitor element
- rows_read - Rows read monitor element
- rows_written - Rows Written monitor element
- sort_overflows - Sort overflows monitor element
- stats_fabricate_time - Total time spent on statistics fabrication activities monitor element
- stmt_pkg_cache_id - Statement package cache identifier monitor element
- stmt_sorts - Statement Sorts monitor element
- stmt_text - SQL statement text monitor element
- sync_runstats_time - Total time spent on synchronous RUNSTATS activities monitor element
- total_exec_time - Elapsed statement execution time monitor element
- total_sort_time - Total sort time monitor element
- total_sys_cpu_time - Total system CPU time for a statement monitor element
- total_usr_cpu_time - Total user CPU time for a statement monitor element
dynsql_list logical data group
fcm logical data group
- buff_free - FCM Buffers Currently Free monitor element
- buff_free_bottom - Minimum FCM Buffers Free monitor element
- buff_max - Maximum possible number of FCM buffers monitor element
- buff_total - Number of currently allocated FCM buffers monitor element
- ch_free - Channels Currently Free monitor element
- ch_free_bottom - Minimum Channels Free monitor element
- ch_max - Maximum possible number of FCM channels monitor element
- ch_total - Number of currently allocated FCM channels monitor element
fcm_node logical data group
hadr logical data group
- hadr_connect_status - HADR Connection Status monitor element
- hadr_connect_time - HADR Connection Time monitor element
- hadr_heartbeat - HADR Heartbeat monitor element
- hadr_local_host - HADR Local Host monitor element
- hadr_local_service - HADR Local Service monitor element
- hadr_log_gap - HADR Log Gap monitor element
- hadr_primary_log_file - HADR Primary Log File monitor element
- hadr_primary_log_lsn - HADR Primary Log LSN monitor element
- hadr_primary_log_page - HADR Primary Log Page monitor element
- hadr_remote_host - HADR Remote Host monitor element
- hadr_remote_instance - HADR Remote Instance monitor element
- hadr_remote_service - HADR Remote Service monitor element
- hadr_role - HADR Role monitor element
- hadr_standby_log_file - HADR Standby Log File monitor element
- hadr_standby_log_lsn - HADR Standby Log LSN monitor element
- hadr_standby_log_page - HADR Standby Log Page monitor element
- hadr_state - HADR State monitor element
- hadr_syncmode - HADR Synchronization Mode monitor element
- hadr_timeout - HADR Timeout monitor element
lock logical data group
- data_partition_id - Data partition identifier monitor element
- lock_attributes - Lock attributes monitor element
- lock_count - Lock count monitor element
- lock_current_mode - Original lock mode before conversion monitor element
- lock_escalation - Lock escalation monitor element
- lock_hold_count - Lock hold count monitor element
- lock_mode - Lock mode monitor element
- lock_name - Lock name monitor element
- lock_object_name - Lock Object Name monitor element
- lock_object_type - Lock object type waited on monitor element
- lock_release_flags - Lock release flags monitor element
- lock_status - Lock status monitor element
- node_number - Node Number monitor element
- table_file_id - Table file ID monitor element
- table_name - Table name monitor element
- table_schema - Table schema name monitor element
- tablespace_name - Table space name monitor element
lock_wait logical data group
- agent_id_holding_lock - Agent ID Holding Lock monitor element
- appl_id_holding_lk - Application ID Holding Lock monitor element
- data_partition_id - Data partition identifier monitor element
- lock_attributes - Lock attributes monitor element
- lock_current_mode - Original lock mode before conversion monitor element
- lock_escalation - Lock escalation monitor element
- lock_mode - Lock mode monitor element
- lock_mode_requested - Lock mode requested monitor element
- lock_name - Lock name monitor element
- lock_object_type - Lock object type waited on monitor element
- lock_release_flags - Lock release flags monitor element
- lock_wait_start_time - Lock wait start timestamp monitor element
- node_number - Node Number monitor element
- ss_number - Subsection number monitor element
- table_name - Table name monitor element
- table_schema - Table schema name monitor element
- tablespace_name - Table space name monitor element
memory_pool logical data group
- node_number - Node Number monitor element
- pool_config_size - Configured Size of Memory Pool monitor element
- pool_cur_size - Current Size of Memory Pool monitor element
- pool_id - Memory Pool Identifier monitor element
- pool_secondary_id - Memory Pool Secondary Identifier monitor element
- pool_watermark - Memory Pool Watermark monitor element
progress logical data group
- progress_completed_units - Completed Progress Work Units monitor element
- progress_description - Progress Description monitor element
- progress_seq_num - Progress Sequence Number monitor element
- progress_start_time - Progress Start Time monitor element
- progress_total_units - Total Progress Work Units monitor element
- progress_work_metric - Progress Work Metric monitor element
progress_list logical data group
rollforward logical data group
stmt logical data group
- agents_top - Number of Agents Created monitor element
- blocking_cursor - Blocking Cursor monitor element
- consistency_token - Package consistency token monitor element
- creator - Application Creator monitor element
- cursor_name - Cursor Name monitor element
- degree_parallelism - Degree of Parallelism monitor element
- fetch_count - Number of Successful Fetches monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- num_agents - Number of Agents Working on a Statement monitor element
- package_name - Package name monitor element
- package_version_id - Package version monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- query_card_estimate - Query Number of Rows Estimate monitor element
- query_cost_estimate - Query cost estimate monitor element
- rows_read - Rows read monitor element
- rows_written - Rows Written monitor element
- section_number - Section number monitor element
- sort_overflows - Sort overflows monitor element
- stmt_elapsed_time - Most Recent Statement Elapsed Time monitor element
- stmt_node_number - Statement Node monitor element
- stmt_operation/operation - Statement operation monitor element
- stmt_sorts - Statement Sorts monitor element
- stmt_start - Statement Operation Start Timestamp monitor element
- stmt_stop - Statement Operation Stop Timestamp monitor element
- stmt_sys_cpu_time - System CPU Time used by Statement monitor element
- stmt_text - SQL statement text monitor element
- stmt_type - Statement type monitor element
- stmt_usr_cpu_time - User CPU Time used by Statement monitor element
- total_sort_time - Total sort time monitor element
stmt_transmissions logical data group
- elapsed_exec_time - Statement Execution Elapsed Time monitor element
- host_response_time - Host Response Time monitor element
- max_data_received_1024 - Number of Statements with Outbound Bytes Received Between 513 and 1024 Bytes monitor element
- max_data_received_128 - Number of Statements with Outbound Bytes Received Between 1 and 128 Bytes monitor element
- max_data_received_16384 - Number of Statements with Outbound Bytes Received Between 8193 and 16384 Bytes monitor element
- max_data_received_2048 - Number of Statements with Outbound Bytes Received Between 1025 and 2048 Bytes monitor element
- max_data_received_256 - Number of Statements with Outbound Bytes Received Between 129 and 256 Bytes monitor element
- max_data_received_31999 - Number of Statements with Outbound Bytes Received Between 16385 and 31999 Bytes monitor element
- max_data_received_4096 - Number of Statements with Outbound Bytes Received Between 2049 and 4096 Bytes monitor element
- max_data_received_512 - Number of Statements with Outbound Bytes Received Between 257 and 512 Bytes monitor element
- max_data_received_64000 - Number of Statements with Outbound Bytes Received Between 32000 and 64000 Bytes monitor element
- max_data_received_8192 - Number of Statements with Outbound Bytes Received Between 4097 and 8192 Bytes monitor element
- max_data_received_gt64000 - Number of Statements with Outbound Bytes Received Greater than 64000 Bytes monitor element
- max_data_sent_1024 - Number of Statements with Outbound Bytes Sent Between 513 and 1024 Bytes monitor element
- max_data_sent_128 - Number of Statements with Outbound Bytes Sent Between 1 and 128 Bytes monitor element
- max_data_sent_16384 - Number of Statements with Outbound Bytes Sent Between 8193 and 16384 Bytes monitor element
- max_data_sent_2048 - Number of Statements with Outbound Bytes Sent Between 1025 and 2048 Bytes monitor element
- max_data_sent_256 - Number of Statements with Outbound Bytes Sent Between 129 and 256 Bytes monitor element
- max_data_sent_31999 - Number of Statements with Outbound Bytes Sent Between 16385 and 31999 Bytes monitor element
- max_data_sent_4096 - Number of Statements with Outbound Bytes Sent Between 2049 and 4096 Bytes monitor element
- max_data_sent_512 - Number of Statements with Outbound Bytes Sent Between 257 and 512 Bytes monitor element
- max_data_sent_64000 - Number of Statements with Outbound Bytes Sent Between 32000 and 64000 Bytes monitor element
- max_data_sent_8192 - Number of Statements with Outbound Bytes Sent Between 4097 and 8192 Bytes monitor element
- max_data_sent_gt64000 - Number of Statements with Outbound Bytes Sent Greater than 64000 Bytes monitor element
- max_network_time_100_ms - Number of Statements with Network Time between 16 and 100 ms monitor element
- max_network_time_16_ms - Number of Statements with Network Time between 4 and 16 ms monitor element
- max_network_time_1_ms - Number of Statements with Network Time of up to 1 ms monitor element
- max_network_time_4_ms - Number of Statements with Network Time between 1 and 4 ms monitor element
- max_network_time_500_ms - Number of Statements with Network Time between 100 and 500 ms monitor element
- max_network_time_gt500_ms - Number of Statements with Network Time greater than 500 ms monitor element
- network_time_bottom - Minimum Network Time for Statement monitor element
- network_time_top - Maximum Network Time for Statement monitor element
- outbound_bytes_received - Outbound Number of Bytes Received monitor element
- outbound_bytes_received_bottom - Minimum Outbound Number of Bytes Received monitor element
- outbound_bytes_received_top - Maximum Outbound Number of Bytes Received monitor element
- outbound_bytes_sent - Outbound Number of Bytes Sent monitor element
- outbound_bytes_sent_bottom - Minimum Outbound Number of Bytes Sent monitor element
- outbound_bytes_sent_top - Maximum Outbound Number of Bytes Sent monitor element
- sql_chains - Number of SQL Chains Attempted monitor element
- sql_stmts - Number of SQL Statements Attempted monitor element
subsection logical data group
- rows_read - Rows read monitor element
- rows_written - Rows Written monitor element
- ss_exec_time - Subsection Execution Elapsed Time monitor element
- ss_node_number - Subsection Node Number monitor element
- ss_number - Subsection number monitor element
- ss_status - Subsection status monitor element
- ss_sys_cpu_time - System CPU Time used by Subsection monitor element
- ss_usr_cpu_time - User CPU Time used by Subsection monitor element
- tq_cur_send_spills - Current number of table queue buffers overflowed monitor element
- tq_id_waiting_on - Waited on node on a table queue monitor element
- tq_max_send_spills - Maximum number of table queue buffers overflows monitor element
- tq_node_waited_for - Waited for node on a table queue monitor element
- tq_rows_read - Number of Rows Read from table queues monitor element
- tq_rows_written - Number of rows written to table queues monitor element
- tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
- tq_wait_for_any - Waiting for any node to send on a table queue monitor element
table logical data group
- data_object_pages - Data Object Pages monitor element
- data_partition_id - Data partition identifier monitor element
- index_object_pages - Index Object Pages monitor element
- lob_object_pages - LOB Object Pages monitor element
- long_object_pages - Long Object Pages monitor element
- overflow_accesses - Accesses to overflowed records monitor element
- page_reorgs - Page reorganizations monitor element
- rows_read - Rows read monitor element
- rows_written - Rows Written monitor element
- table_file_id - Table file ID monitor element
- table_name - Table name monitor element
- table_schema - Table schema name monitor element
- table_type - Table type monitor element
- tablespace_id - Table space identification monitor element
- xda_object_pages - XDA Object Pages monitor element
table_list logical data group
table_reorg logical data group
- data_partition_id - Data partition identifier monitor element
- reorg_completion - Reorganization Completion Flag monitor element
- reorg_current_counter - Reorganize Progress monitor element
- reorg_end - Table Reorganize End Time monitor element
- reorg_index_id - Index Used to Reorganize the Table monitor element
- reorg_max_counter - Total Amount of Reorganization monitor element
- reorg_max_phase - Maximum Reorganize Phase monitor element
- reorg_phase - Table reorganization phase monitor element
- reorg_phase_start - Reorganize Phase Start Time monitor element
- reorg_rows_compressed - Rows Compressed monitor element
- reorg_rows_rejected_for_compression - Rows Rejected for Compression monitor element
- reorg_start - Table Reorganize Start Time monitor element
- reorg_status - Table Reorganize Status monitor element
- reorg_tbspc_id - Table Space Where Table or Data partition is Reorganized monitor element
- reorg_type - Table Reorganize Attributes monitor element
- reorg_xml_regions_compressed - XML regions compressed monitor element
- reorg_xml_regions_rejected_for_compression - XML regions rejected for compression monitor element
tablespace logical data group
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- files_closed - Database files closed monitor element
- fs_caching - File system caching monitor element
- pool_async_data_read_reqs - Buffer pool asynchronous read requests monitor element
- pool_async_data_reads - Buffer pool asynchronous data reads monitor element
- pool_async_data_writes - Buffer pool asynchronous data writes monitor element
- pool_async_index_read_reqs - Buffer pool asynchronous index read requests monitor element
- pool_async_index_reads - Buffer pool asynchronous index reads monitor element
- pool_async_index_writes - Buffer pool asynchronous index writes monitor element
- pool_async_read_time - Buffer Pool Asynchronous Read Time monitor element
- pool_async_write_time - Buffer pool asynchronous write time monitor element
- pool_async_xda_read_reqs - Buffer pool asynchronous XDA read requests monitor element
- pool_async_xda_reads - Buffer pool asynchronous XDA data reads monitor element
- pool_async_xda_writes - Buffer pool asynchronous XDA data writes monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_no_victim_buffer - Buffer pool no victim buffers monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- tablespace_auto_resize_enabled - Table space automatic resizing enabled monitor element
- tablespace_content_type - Table space content type monitor element
- tablespace_cur_pool_id - Buffer pool currently being used monitor element
- tablespace_extent_size - Table space extent size monitor element
- tablespace_id - Table space identification monitor element
- tablespace_name - Table space name monitor element
- tablespace_next_pool_id - Buffer pool that will be used at next startup monitor element
- tablespace_page_size - Table space page size monitor element
- tablespace_prefetch_size - Table space prefetch size monitor element
- rebalancer_mode - Rebalancer mode monitor element
- tablespace_type - Table space type monitor element
- tablespace_using_auto_storage - Table space enabled for automatic storage monitor element
tablespace_container logical data group
- container_accessible - Accessibility of container monitor element
- container_id - Container identification monitor element
- container_name - Container name monitor element
- container_stripe_set - Container stripe set monitor element
- container_total_pages - Total pages in container monitor element
- container_type - Container type monitor element
- container_usable_pages - Usable pages in container monitor element
tablespace_list logical data group
tablespace_nodeinfo logical data group
- tablespace_current_size - Current table space size monitor element
- tablespace_free_pages - Free pages in table space monitor element
- tablespace_increase_size - Increase size in bytes monitor element
- tablespace_increase_size_percent - Increase size by percent monitor element
- tablespace_initial_size - Initial table space size monitor element
- tablespace_last_resize_failed - Last resize attempt failed monitor element
- tablespace_last_resize_time - Time of last successful resize monitor element
- tablespace_max_size - Maximum table space size monitor element
- tablespace_min_recovery_time - Minimum recovery time for rollforward monitor element
- tablespace_num_containers - Number of Containers in Table Space monitor element
- tablespace_num_quiescers - Number of Quiescers monitor element
- tablespace_num_ranges - Number of Ranges in the Table Space Map monitor element
- tablespace_page_top - Table space high watermark monitor element
- tablespace_paths_dropped - Table space using dropped path monitor element
- tablespace_pending_free_pages - Pending free pages in table space monitor element
- tablespace_prefetch_size - Table space prefetch size monitor element
- rebalancer_extents_processed - Number of extents the rebalancer has processed monitor element
- rebalancer_extents_remaining - Total number of extents to be processed by the rebalancer monitor element
- rebalancer_last_extent_moved - Last extent moved by the rebalancer monitor element
- rebalancer_priority - Current rebalancer priority monitor element
- rebalancer_restart_time - Rebalancer restart time monitor element
- rebalancer_start_time - Rebalancer start time monitor element
- tablespace_state - Table space state monitor element
- tablespace_state_change_object_id - State Change Object Identification monitor element
- tablespace_state_change_ts_id - State Change Table Space Identification monitor element
- tablespace_total_pages - Total pages in table space monitor element
- tablespace_usable_pages - Usable pages in table space monitor element
- tablespace_used_pages - Used pages in table space monitor element
tablespace_quiescer logical data group
- quiescer_agent_id - Quiescer Agent Identification monitor element
- quiescer_auth_id - Quiescer User Authorization Identification monitor element
- quiescer_obj_id - Quiescer Object Identification monitor element
- quiescer_state - Quiescer State monitor element
- quiescer_ts_id - Quiescer Table Space Identification monitor element
tablespace_range logical data group
- range_adjustment - Range Adjustment monitor element
- range_container_id - Range Container monitor element
- range_end_stripe - End Stripe monitor element
- range_max_extent - Maximum Extent in Range monitor element
- range_max_page_number - Maximum Page in Range monitor element
- range_num_container - Number of Containers in Range monitor element
- range_number - Range Number monitor element
- range_offset - Range Offset monitor element
- range_start_stripe - Start Stripe monitor element
- range_stripe_set_number - Stripe Set Number monitor element
utility_info logical data group
- node_number - Node Number monitor element
- utility_dbname - Database Operated on by Utility monitor element
- utility_description - Utility Description monitor element
- utility_id - Utility ID monitor element
- utility_invoker_type - Utility Invoker Type monitor element
- utility_priority - Utility Priority monitor element
- utility_start_time - Utility Start Time monitor element
- utility_state - Utility State monitor element
- utility_type - Utility Type monitor element