Snapshot monitor logical data groups and monitor elements

• 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

• agent_pid - Engine dispatchable unit (EDU) identifier monitor element
• lock_timeout_val - Lock timeout value monitor element

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
• priv_workspace_num_overflows - Private Workspace Overflows monitor element
• priv_workspace_section_inserts - Private Workspace Section Inserts monitor element
• priv_workspace_section_lookups - Private Workspace Section Lookups monitor element
• priv_workspace_size_top - Maximum Private Workspace Size 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
• shr_workspace_num_overflows - Shared Workspace Overflows monitor element
• shr_workspace_section_inserts - Shared Workspace Section Inserts monitor element
• shr_workspace_section_lookups - Shared Workspace Section Lookups monitor element
• shr_workspace_size_top - Maximum Shared Workspace Size 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/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
• priv_workspace_num_overflows - Private Workspace Overflows monitor element
• priv_workspace_section_inserts - Private Workspace Section Inserts monitor element
• priv_workspace_section_lookups - Private Workspace Section Lookups monitor element
• priv_workspace_size_top - Maximum Private Workspace Size 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
• shr_workspace_num_overflows - Shared Workspace Overflows monitor element
• shr_workspace_section_inserts - Shared Workspace Section Inserts monitor element
• shr_workspace_section_lookups - Shared Workspace Section Lookups monitor element
• shr_workspace_size_top - Maximum Shared Workspace Size 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/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

• db_storage_path - Automatic storage path monitor element
• 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_sz - 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_pkgcache_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

• db_name - Database Name monitor element
• db_path - Database Path monitor element

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

• connection_status - Connection status monitor element
• node_number - Node Number monitor element
• total_buffers_rcvd - Total FCM buffers received monitor element
• total_buffers_sent - Total FCM buffers sent monitor element

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

• progress_list_attr - Current Progress List Attributes monitor element
• progress_list_cur_seq_num - Current Progress List Sequence Number monitor element

rollforward logical data group

• node_number - Node Number monitor element
• rf_log_num - Log Being Rolled Forward monitor element
• rf_status - Log Phase monitor element
• rf_timestamp - Rollforward Timestamp monitor element
• rf_type - Rollforward Type monitor element
• ts_name - Table space being rolled forward monitor element

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

• db_conn_time - Database activation timestamp monitor element
• db_name - Database Name monitor element
• db_path - Database Path monitor element
• input_db_alias - Input Database Alias monitor element
• last_reset - Last Reset Timestamp monitor element

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
• tablespace_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

• db_conn_time - Database activation timestamp monitor element
• db_name - Database Name monitor element
• db_path - Database Path monitor element
• input_db_alias - Input Database Alias monitor element
• last_reset - Last Reset Timestamp monitor element

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
• tablespace_rebalancer_extents_processed - Number of Extents the Rebalancer has Processed monitor element
• tablespace_rebalancer_extents_remaining - Total Number of Extents to be Processed by the Rebalancer monitor element
• tablespace_rebalancer_last_extent_moved - Last Extent Moved by the Rebalancer monitor element
• tablespace_rebalancer_priority - Current Rebalancer Priority monitor element
• tablespace_rebalancer_restart_time - Rebalancer Restart Time monitor element
• tablespace_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_containers - 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