MON_GET_DATABASE table function - Get database metrics

The MON_GET_DATABASE table function returns database level information within the monitor infrastructure.

Authorization

One of the following authorizations is required:
  • EXECUTE privilege on the routine
  • DATAACCESS authority
  • DBADM authority
  • SQLADM authority

Default PUBLIC privilege

None

Syntax

Read syntax diagramSkip visual syntax diagramMON_GET_DATABASE(member)

The schema is SYSPROC.

Routine parameters

member
An input parameter of type INTEGER that specifies a valid database member from which the records should be fetched. Specify -1 or null for the current member, or -2 for information from all active database members. An active database member is a database that is available for connection and use by applications.

Information returned

Table 1. Information returned by the MON_GET_DATABASE routine
Column name Data type Description
MEMBER SMALLINT member - Database member monitor element
DB_STATUS VARCHAR(16) db_status - Status of database monitor element
DB_ACTIVATION_STATE VARCHAR(10) db_activation_state - Database activation state
DB_CONN_TIME TIMESTAMP db_conn_time - Database activation timestamp monitor element
CATALOG_PARTITION SMALLINT catalog_node - Catalog Node Number
LAST_BACKUP TIMESTAMP last_backup - Last Backup Timestamp monitor element
CONNECTIONS_TOP BIGINT connections_top - Maximum Number of Concurrent Connections monitor element
TOTAL_CONS BIGINT total_cons - Connects Since Database Activation monitor element
TOTAL_SEC_CONS BIGINT total_sec_cons - Secondary Connections monitor element
APPLS_CUR_CONS BIGINT appls_cur_cons - Applications Connected Currently monitor element
APPLS_IN_DB2 BIGINT appls_in_db2 - Applications Executing in the Database Currently monitor element
NUM_ASSOC_AGENTS BIGINT num_assoc_agents - Number of Associated Agents monitor element
AGENTS_TOP BIGINT agents_top - Number of Agents Created monitor element
NUM_COORD_AGENTS BIGINT num_coord_agents - Number of coordinator agents
COORD_AGENTS_TOP BIGINT coord_agents_top - Maximum Number of Coordinating Agents monitor element
NUM_LOCKS_HELD BIGINT locks_held - Locks held monitor element
NUM_LOCKS_WAITING BIGINT locks_waiting - Current agents waiting on locks monitor element
LOCK_LIST_IN_USE BIGINT lock_list_in_use - Total lock list memory in use monitor element
ACTIVE_SORTS BIGINT active_sorts - Active Sorts monitor element
ACTIVE_HASH_JOINS BIGINT active_hash_joins - Active hash joins monitor element
ACTIVE_OLAP_FUNCS BIGINT active_olap_funcs - Active OLAP Functions monitor element
DB_PATH VARCHAR(1024) db_path - Database Path monitor element
ACT_ABORTED_TOTAL BIGINT act_aborted_total - Total aborted activities monitor element
ACT_COMPLETED_TOTAL BIGINT act_completed_total - Total completed activities monitor element
ACT_REJECTED_TOTAL BIGINT act_rejected_total - Total rejected activities monitor element
AGENT_WAIT_TIME BIGINT agent_wait_time - Agent wait time monitor element
AGENT_WAITS_TOTAL BIGINT agent_waits_total - Total agent waits monitor element
POOL_DATA_L_READS BIGINT pool_data_l_reads - Buffer pool data logical reads monitor element
POOL_INDEX_L_READS BIGINT pool_index_l_reads - Buffer pool index logical reads monitor element
POOL_TEMP_DATA_L_READS BIGINT pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
POOL_TEMP_INDEX_L_READS BIGINT pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
POOL_TEMP_XDA_L_READS BIGINT pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
POOL_XDA_L_READS BIGINT pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
POOL_DATA_P_READS BIGINT pool_data_p_reads - Buffer pool data physical reads monitor element
POOL_INDEX_P_READS BIGINT pool_index_p_reads - Buffer pool index physical reads monitor element
POOL_TEMP_DATA_P_READS BIGINT pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
POOL_TEMP_INDEX_P_READS BIGINT pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
POOL_TEMP_XDA_P_READS BIGINT pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
POOL_XDA_P_READS BIGINT pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
POOL_DATA_WRITES BIGINT pool_data_writes - Buffer pool data writes monitor element
POOL_INDEX_WRITES BIGINT pool_index_writes - Buffer pool index writes monitor element
POOL_XDA_WRITES BIGINT pool_xda_writes - Buffer pool XDA data writes monitor element
POOL_READ_TIME BIGINT pool_read_time - Total buffer pool physical read time monitor element
POOL_WRITE_TIME BIGINT pool_write_time - Total buffer pool physical write time monitor element
CLIENT_IDLE_WAIT_TIME BIGINT client_idle_wait_time - Client idle wait time monitor element
DEADLOCKS BIGINT deadlocks - Deadlocks detected monitor element
DIRECT_READS BIGINT direct_reads - Direct reads from database monitor element
DIRECT_READ_TIME BIGINT direct_read_time - Direct read time monitor element
DIRECT_WRITES BIGINT direct_writes - Direct writes to database monitor element
DIRECT_WRITE_TIME BIGINT direct_write_time - Direct write time monitor element
DIRECT_READ_REQS BIGINT direct_read_reqs - Direct read requests monitor element
DIRECT_WRITE_REQS BIGINT direct_write_reqs - Direct write requests monitor element
FCM_RECV_VOLUME BIGINT fcm_recv_volume - FCM received volume monitor element
FCM_RECVS_TOTAL BIGINT fcm_recvs_total - FCM receives total monitor element
FCM_SEND_VOLUME BIGINT fcm_send_volume - FCM send volume monitor element
FCM_SENDS_TOTAL BIGINT fcm_sends_total - FCM sends total monitor element
FCM_RECV_WAIT_TIME BIGINT fcm_recv_wait_time - FCM received wait time monitor element
FCM_SEND_WAIT_TIME BIGINT fcm_send_wait_time - FCM send wait time monitor element
IPC_RECV_VOLUME BIGINT ipc_recv_volume - Interprocess communication received volume monitor element
IPC_RECV_WAIT_TIME BIGINT ipc_recv_wait_time - Interprocess communication received wait time monitor element
IPC_RECVS_TOTAL BIGINT ipc_recvs_total - Interprocess communication receives total monitor element
IPC_SEND_VOLUME BIGINT ipc_send_volume - Interprocess communication send volume monitor element
IPC_SEND_WAIT_TIME BIGINT ipc_send_wait_time - Interprocess communication send wait time monitor element
IPC_SENDS_TOTAL BIGINT ipc_sends_total - Interprocess communication send total monitor element
LOCK_ESCALS BIGINT lock_escals - Number of lock escalations monitor element
LOCK_TIMEOUTS BIGINT lock_timeouts - Number of lock timeouts monitor element
LOCK_WAIT_TIME BIGINT lock_wait_time - Time waited on locks monitor element
LOCK_WAITS BIGINT lock_waits - Lock waits monitor element
LOG_BUFFER_WAIT_TIME BIGINT log_buffer_wait_time - Log buffer wait time monitor element
NUM_LOG_BUFFER_FULL BIGINT num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
LOG_DISK_WAIT_TIME BIGINT log_disk_wait_time - Log disk wait time monitor element
LOG_DISK_WAITS_TOTAL BIGINT log_disk_waits_total - Total log disk waits monitor element
RQSTS_COMPLETED_TOTAL BIGINT rqsts_completed_total - Total requests completed monitor element
ROWS_MODIFIED BIGINT rows_modified - Rows modified monitor element
ROWS_READ BIGINT rows_read - Rows read monitor element
ROWS_RETURNED BIGINT rows_returned - Rows returned monitor element
TCPIP_RECV_VOLUME BIGINT tcpip_recv_volume - TCP/IP received volume monitor element
TCPIP_SEND_VOLUME BIGINT tcpip_send_volume - TCP/IP send volume monitor element
TCPIP_RECV_WAIT_TIME BIGINT tcpip_recv_wait_time - TCP/IP received wait time monitor element
TCPIP_RECVS_TOTAL BIGINT tcpip_recvs_total - TCP/IP receives total monitor element
TCPIP_SEND_WAIT_TIME BIGINT tcpip_send_wait_time - TCP/IP send wait time monitor element
TCPIP_SENDS_TOTAL BIGINT tcpip_sends_total - TCP/IP sends total monitor element
TOTAL_APP_RQST_TIME BIGINT total_app_rqst_time - Total application request time monitor element
TOTAL_RQST_TIME BIGINT total_rqst_time - Total request time monitor element
WLM_QUEUE_TIME_TOTAL BIGINT wlm_queue_time_total - Workload manager total queue time monitor element
WLM_QUEUE_ASSIGNMENTS_TOTAL BIGINT wlm_queue_assignments_total - Workload manager total queue assignments monitor element
TOTAL_RQST_MAPPED_IN BIGINT total_rqst_mapped_in - Total request mapped-in monitor element
TOTAL_RQST_MAPPED_OUT BIGINT total_rqst_mapped_out - Total request mapped-out monitor element
TOTAL_CPU_TIME BIGINT total_cpu_time - Total CPU time monitor element
TOTAL_WAIT_TIME BIGINT total_wait_time - Total wait time monitor element
APP_RQSTS_COMPLETED_TOTAL BIGINT app_rqsts_completed_total - Total application requests completed monitor element
TOTAL_SECTION_SORT_TIME BIGINT total_section_sort_time - Total section sort time monitor element
TOTAL_SECTION_SORT_PROC_TIME BIGINT total_section_sort_proc_time - Total section sort processing time monitor element
TOTAL_SECTION_SORTS BIGINT total_section_sorts - Total section sorts monitor element
TOTAL_SORTS BIGINT total_sorts - Total sorts monitor element
POST_THRESHOLD_SORTS BIGINT post_threshold_sorts - Post threshold sorts monitor element
POST_SHRTHRESHOLD_SORTS BIGINT post_shrthreshold_sorts - Post shared threshold sorts monitor element
SORT_OVERFLOWS BIGINT sort_overflows - Sort overflows monitor element
TOTAL_COMPILE_TIME BIGINT total_compile_time - Total compile time monitor element
TOTAL_COMPILE_PROC_TIME BIGINT total_compile_proc_time - Total compile processing time monitor element
TOTAL_COMPILATIONS BIGINT total_compilations - Total compilations monitor element
TOTAL_IMPLICIT_COMPILE_TIME BIGINT total_implicit_compile_time - Total implicit compile time monitor element
TOTAL_IMPLICIT_COMPILE_PROC_TIME BIGINT total_implicit_compile_proc_time - Total implicit compile processing time monitor element
TOTAL_IMPLICIT_COMPILATIONS BIGINT total_implicit_compilations - Total implicit complications monitor element
TOTAL_SECTION_TIME BIGINT total_section_time - Total section time monitor element
TOTAL_SECTION_PROC_TIME BIGINT total_section_proc_time - Total section processing time monitor element
TOTAL_APP_SECTION_EXECUTIONS BIGINT total_app_section_executions - Total application section executions monitor element
TOTAL_ACT_TIME BIGINT total_act_time - Total activity time monitor element
TOTAL_ACT_WAIT_TIME BIGINT total_act_wait_time - Total activity wait time monitor element
ACT_RQSTS_TOTAL BIGINT act_rqsts_total - Total activity requests monitor elements
TOTAL_ROUTINE_TIME BIGINT total_routine_time - Total routine time monitor element
TOTAL_ROUTINE_INVOCATIONS BIGINT total_routine_invocations - Total routine invocations monitor elements
TOTAL_COMMIT_TIME BIGINT total_commit_time - Total commit time monitor element
TOTAL_COMMIT_PROC_TIME BIGINT total_commit_proc_time - Total commits processing time monitor element
TOTAL_APP_COMMITS BIGINT total_app_commits - Total application commits monitor elements
INT_COMMITS BIGINT int_commits - Internal commits monitor element
TOTAL_ROLLBACK_TIME BIGINT total_rollback_time - Total rollback time monitor element
TOTAL_ROLLBACK_PROC_TIME BIGINT total_rollback_proc_time - Total rollback processing time monitor element
TOTAL_APP_ROLLBACKS BIGINT total_app_rollbacks - Total application rollbacks monitor element
INT_ROLLBACKS BIGINT int_rollbacks - Internal rollbacks monitor element
TOTAL_RUNSTATS_TIME BIGINT total_runstats_time - Total runtime statistics time monitor element
TOTAL_RUNSTATS_PROC_TIME BIGINT total_runstats_proc_time - Total runtime statistics processing time monitor element
TOTAL_RUNSTATS BIGINT total_runstats - Total runtime statistics monitor element
TOTAL_REORG_TIME BIGINT total_reorg_time - Total reorganization time monitor element
TOTAL_REORG_PROC_TIME BIGINT total_reorg_proc_time - Total reorganization processing time monitor element
TOTAL_REORGS BIGINT total_reorgs - Total reorganizations monitor element
TOTAL_LOAD_TIME BIGINT total_load_time - Total load time monitor element
TOTAL_LOAD_PROC_TIME BIGINT total_load_proc_time - Total load processing time monitor element
TOTAL_LOADS BIGINT total_loads - Total loads monitor element
CAT_CACHE_INSERTS BIGINT cat_cache_inserts - Catalog cache inserts monitor element
CAT_CACHE_LOOKUPS BIGINT cat_cache_lookups - Catalog cache lookups monitor element
PKG_CACHE_INSERTS BIGINT pkg_cache_inserts - Package cache inserts monitor element
PKG_CACHE_LOOKUPS BIGINT pkg_cache_lookups - Package cache lookups monitor element
THRESH_VIOLATIONS BIGINT thresh_violations - Number of threshold violations monitor element
NUM_LW_THRESH_EXCEEDED BIGINT num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
LOCK_WAITS_GLOBAL BIGINT lock_waits_global - Lock waits global monitor element
LOCK_WAIT_TIME_GLOBAL BIGINT lock_wait_time_global - Lock wait time global monitor element
LOCK_TIMEOUTS_GLOBAL BIGINT lock_timeouts_global - Lock timeouts global monitor element
LOCK_ESCALS_MAXLOCKS BIGINT lock_escals_maxlocks - Number of maxlocks lock escalations monitor element
LOCK_ESCALS_LOCKLIST BIGINT lock_escals_locklist - Number of locklist lock escalations monitor element
LOCK_ESCALS_GLOBAL BIGINT lock_escals_global - Number of global lock escalations monitor element
DATA_SHARING_REMOTE_LOCKWAIT_COUNT BIGINT data_sharing_remote_lockwait_count - Data sharing remote lock wait count monitor element
DATA_SHARING_REMOTE_LOCKWAIT_TIME BIGINT data_sharing_remote_lockwait_time - Data sharing remote lock wait time monitor element
RECLAIM_WAIT_TIME BIGINT reclaim_wait_time - Reclaim wait time monitor element
SPACEMAPPAGE_RECLAIM_WAIT_TIME BIGINT spacemappage_reclaim_wait_time - Space map page reclaim wait time monitor element
CF_WAITS BIGINT cf_waits - Number of cluster caching facility waits monitor element
CF_WAIT_TIME BIGINT cf_wait_time - cluster caching facility wait time monitor element
POOL_DATA_GBP_L_READS BIGINT pool_data_gbp_l_reads - Group buffer pool data logical reads monitor element
POOL_DATA_GBP_P_READS BIGINT pool_data_gbp_p_reads - Group buffer pool data physical reads monitor element
POOL_DATA_LBP_PAGES_FOUND BIGINT pool_data_lbp_pages_found - Local buffer pool found data pages monitor element
POOL_DATA_GBP_INVALID_PAGES BIGINT pool_data_gbp_invalid_pages - Group buffer pool invalid data pages monitor element
POOL_INDEX_GBP_L_READS BIGINT pool_index_gbp_l_reads - Group buffer pool index logical reads monitor element
POOL_INDEX_GBP_P_READS BIGINT pool_index_gbp_p_reads - Group buffer pool index physical reads monitor elements
POOL_INDEX_LBP_PAGES_FOUND BIGINT pool_index_lbp_pages_found - Local buffer pool index pages found monitor element
POOL_INDEX_GBP_INVALID_PAGES BIGINT pool_index_gbp_invalid_pages - Group buffer pool invalid index pages monitor element
POOL_XDA_GBP_L_READS BIGINT pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests monitor element
POOL_XDA_GBP_P_READS BIGINT pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests monitor element
POOL_XDA_LBP_PAGES_FOUND BIGINT pool_xda_lbp_pages_found - Local buffer pool XDA data pages found monitor element
POOL_XDA_GBP_INVALID_PAGES BIGINT pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages monitor element
AUDIT_EVENTS_TOTAL BIGINT audit_events_total - Total audit events monitor element
AUDIT_FILE_WRITES_TOTAL BIGINT audit_file_writes_total - Total audit files written monitor element
AUDIT_FILE_WRITE_WAIT_TIME BIGINT audit_file_write_wait_time - Audit file write wait time monitor element
AUDIT_SUBSYSTEM_WAITS_TOTAL BIGINT audit_subsystem_waits_total - Total audit subsystem waits monitor element
AUDIT_SUBSYSTEM_WAIT_TIME BIGINT audit_subsystem_wait_time - Audit subsystem wait time monitor element
DIAGLOG_WRITES_TOTAL BIGINT diaglog_writes_total - Total diagnostic log file writes monitor element
DIAGLOG_WRITE_WAIT_TIME BIGINT diaglog_write_wait_time - Diagnostic log file write wait time monitor element
FCM_MESSAGE_RECVS_TOTAL BIGINT fcm_message_recvs_total - Total FCM message receives monitor element
FCM_MESSAGE_RECV_VOLUME BIGINT fcm_message_recv_volume - FCM message received volume monitor element
FCM_MESSAGE_RECV_WAIT_TIME BIGINT fcm_message_recv_wait_time - FCM message received wait time monitor element
FCM_MESSAGE_SENDS_TOTAL BIGINT fcm_message_sends_total - Total FCM message sends monitor element
FCM_MESSAGE_SEND_VOLUME BIGINT fcm_message_send_volume - FCM message send volume monitor element
FCM_MESSAGE_SEND_WAIT_TIME BIGINT fcm_message_send_wait_time - FCM message send wait time monitor element
FCM_TQ_RECVS_TOTAL BIGINT fcm_tq_recvs_total - FCM table queue receives total monitor element
FCM_TQ_RECV_VOLUME BIGINT fcm_tq_recv_volume - FCM table queue received volume monitor element
FCM_TQ_RECV_WAIT_TIME BIGINT fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
FCM_TQ_SENDS_TOTAL BIGINT fcm_tq_sends_total - FCM table queue send total monitor element
FCM_TQ_SEND_VOLUME BIGINT fcm_tq_send_volume - FCM table queue send volume monitor element
FCM_TQ_SEND_WAIT_TIME BIGINT fcm_tq_send_wait_time - FCM table queue send wait time monitor element
TOTAL_ROUTINE_USER_CODE_PROC_TIME BIGINT total_routine_user_code_proc_time - Total routine user code processing time monitor element
TOTAL_ROUTINE_USER_CODE_TIME BIGINT total_routine_user_code_time - Total routine user code time monitor element
TQ_TOT_SEND_SPILLS BIGINT tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
EVMON_WAIT_TIME BIGINT evmon_wait_time - Event monitor wait time monitor element
EVMON_WAITS_TOTAL BIGINT evmon_waits_total - Event monitor total waits monitor element
TOTAL_EXTENDED_LATCH_WAIT_TIME BIGINT total_extended_latch_wait_time - Total extended latch wait time monitor element
TOTAL_EXTENDED_LATCH_WAITS BIGINT total_extended_latch_waits - Total extended latch waits monitor element
TOTAL_STATS_FABRICATION_TIME BIGINT total_stats_fabrication_time - Total statistics fabrication time monitor element
TOTAL_STATS_FABRICATION_PROC_TIME BIGINT total_stats_fabrication_proc_time - Total statistics fabrication processing time monitor element
TOTAL_STATS_FABRICATIONS BIGINT total_stats_fabrications - Total statistics fabrications monitor elements
TOTAL_SYNC_RUNSTATS_TIME BIGINT total_sync_runstats_time - Total synchronous RUNSTATS time monitor elements
TOTAL_SYNC_RUNSTATS_PROC_TIME BIGINT total_sync_runstats_proc_time - Total synchronous RUNSTATS processing time monitor element
TOTAL_SYNC_RUNSTATS BIGINT total_sync_runstats - Total synchronous RUNSTATS activities monitor element
TOTAL_DISP_RUN_QUEUE_TIME BIGINT total_disp_run_queue_time - Total dispatcher run queue time monitor element
TOTAL_PEDS BIGINT total_peds - Total partial early distincts monitor element
DISABLED_PEDS BIGINT disabled_peds - Disabled partial early distincts monitor element
POST_THRESHOLD_PEDS BIGINT post_threshold_peds - Partial early distincts threshold monitor element
TOTAL_PEAS BIGINT total_peas - Total partial early aggregations monitor element
POST_THRESHOLD_PEAS BIGINT post_threshold_peas - Partial early aggregation threshold monitor element
TQ_SORT_HEAP_REQUESTS BIGINT tq_sort_heap_requests - Table queue sort heap requests monitor element
TQ_SORT_HEAP_REJECTIONS BIGINT tq_sort_heap_rejections - Table queue sort heap rejections monitor element
POOL_QUEUED_ASYNC_DATA_REQS BIGINT pool_queued_async_data_reqs - Data prefetch requests monitor element
POOL_QUEUED_ASYNC_INDEX_REQS BIGINT pool_queued_async_index_reqs - Index prefetch requests monitor element
POOL_QUEUED_ASYNC_XDA_REQS BIGINT pool_queued_async_xda_reqs - XDA prefetch requests monitor element
POOL_QUEUED_ASYNC_TEMP_DATA_REQS BIGINT pool_queued_async_temp_data_reqs - Data prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_TEMP_INDEX_REQS BIGINT pool_queued_async_temp_index_reqs - Index prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_TEMP_XDA_REQS BIGINT pool_queued_async_temp_xda_reqs - XDA data prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_OTHER_REQS BIGINT pool_queued_async_other_reqs - Other requests handled by prefetchers monitor element
POOL_QUEUED_ASYNC_DATA_PAGES BIGINT pool_queued_async_data_pages - Data pages prefetch requests monitor element
POOL_QUEUED_ASYNC_INDEX_PAGES BIGINT pool_queued_async_index_pages - Index pages prefetch requests monitor element
POOL_QUEUED_ASYNC_XDA_PAGES BIGINT pool_queued_async_xda_pages - XDA pages prefetch requests monitor element
POOL_QUEUED_ASYNC_TEMP_DATA_PAGES BIGINT pool_queued_async_temp_data_pages - Data pages prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_TEMP_INDEX_PAGES BIGINT pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
POOL_QUEUED_ASYNC_TEMP_XDA_PAGES BIGINT pool_queued_async_temp_xda_pages - XDA data pages prefetch requests for temporary table spaces monitor element
POOL_FAILED_ASYNC_DATA_REQS BIGINT pool_failed_async_data_reqs - Failed data prefetch requests monitor element
POOL_FAILED_ASYNC_INDEX_REQS BIGINT pool_failed_async_index_reqs - Failed index prefetch requests monitor element
POOL_FAILED_ASYNC_XDA_REQS BIGINT pool_failed_async_xda_reqs - Failed XDA prefetch requests monitor element
POOL_FAILED_ASYNC_TEMP_DATA_REQS BIGINT pool_failed_async_temp_data_reqs - Failed data prefetch requests for temporary table spaces monitor element
POOL_FAILED_ASYNC_TEMP_INDEX_REQS BIGINT pool_failed_async_temp_index_reqs - Failed index prefetch requests for temporary table spaces monitor element
POOL_FAILED_ASYNC_TEMP_XDA_REQS BIGINT pool_failed_async_temp_xda_reqs - Failed XDA prefetch requests for temporary table spaces monitor element
POOL_FAILED_ASYNC_OTHER_REQS BIGINT pool_failed_async_other_reqs - Failed non-prefetch requests monitor element
PREFETCH_WAIT_TIME BIGINT prefetch_wait_time - Time waited for prefetch monitor element
PREFETCH_WAITS BIGINT prefetch_waits - Prefetcher wait count monitor element
APP_ACT_COMPLETED_TOTAL BIGINT app_act_completed_total - Total successful external coordinator activities monitor element
APP_ACT_ABORTED_TOTAL BIGINT app_act_aborted_total - Total failed external coordinator activities monitor element
APP_ACT_REJECTED_TOTAL BIGINT app_act_rejected_total - Total rejected external coordinator activities monitor element
TOTAL_CONNECT_REQUEST_TIME BIGINT total_connect_request_time - Total connection or switch user request time monitor element
TOTAL_CONNECT_REQUEST_PROC_TIME BIGINT total_connect_request_proc_time - Total connection or switch user request processing time monitor element
TOTAL_CONNECT_REQUESTS BIGINT total_connect_requests - Connection or switch user requests monitor element
TOTAL_CONNECT_AUTHENTICATION_TIME BIGINT total_connect_authentication_time - Total connection or switch user authentication request time monitor element
TOTAL_CONNECT_AUTHENTICATION_PROC_TIME BIGINT total_connect_authentication_proc_time - Total connection authentication processing time monitor element
TOTAL_CONNECT_AUTHENTICATIONS BIGINT total_connect_authentications - Connections or switch user authentications performed monitor element
POOL_DATA_GBP_INDEP_PAGES_FOUND_IN_LBP BIGINT pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool monitor element
POOL_INDEX_GBP_INDEP_PAGES_FOUND_IN_LBP BIGINT pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool monitor element
POOL_XDA_GBP_INDEP_PAGES_FOUND_IN_LBP BIGINT pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool monitor element
COMM_EXIT_WAIT_TIME BIGINT comm_exit_wait_time - Communication buffer exit wait time monitor element
COMM_EXIT_WAITS BIGINT comm_exit_waits - Communication buffer exit number of waits monitor element
POOL_ASYNC_DATA_READS BIGINT pool_async_data_reads - Buffer pool asynchronous data reads monitor element
POOL_ASYNC_DATA_READ_REQS BIGINT pool_async_data_read_reqs - Buffer pool asynchronous read requests monitor element
POOL_ASYNC_DATA_WRITES BIGINT pool_async_data_writes - Buffer pool asynchronous data writes monitor element
POOL_ASYNC_INDEX_READS BIGINT pool_async_index_reads - Buffer pool asynchronous index reads monitor element
POOL_ASYNC_INDEX_READ_REQS BIGINT pool_async_index_read_reqs - Buffer pool asynchronous index read requests monitor element
POOL_ASYNC_INDEX_WRITES BIGINT pool_async_index_writes - Buffer pool asynchronous index writes monitor element
POOL_ASYNC_XDA_READS BIGINT pool_async_xda_reads - Buffer pool asynchronous XDA data reads monitor element
POOL_ASYNC_XDA_READ_REQS BIGINT pool_async_xda_read_reqs - Buffer pool asynchronous XDA read requests monitor element
POOL_ASYNC_XDA_WRITES BIGINT pool_async_xda_writes - Buffer pool asynchronous XDA data writes monitor element
POOL_NO_VICTIM_BUFFER BIGINT pool_no_victim_buffer - Buffer pool no victim buffers monitor element
POOL_LSN_GAP_CLNS BIGINT pool_lsn_gap_clns - Buffer pool log space cleaners triggered monitor element
POOL_DRTY_PG_STEAL_CLNS BIGINT pool_drty_pg_steal_clns - Buffer pool victim page cleaners triggered monitor element
POOL_DRTY_PG_THRSH_CLNS BIGINT pool_drty_pg_thrsh_clns - Buffer pool threshold cleaners triggered monitor element
VECTORED_IOS BIGINT vectored_ios - Number of vectored I/O requests monitor element
PAGES_FROM_VECTORED_IOS BIGINT pages_from_vectored_ios - Total number of pages read by vectored I/O monitor element
BLOCK_IOS BIGINT block_ios - Number of block I/O requests monitor element
PAGES_FROM_BLOCK_IOS BIGINT pages_from_block_ios - Total number of pages read by block I/O monitor element
UNREAD_PREFETCH_PAGES BIGINT unread_prefetch_pages - Unread prefetch pages monitor element
FILES_CLOSED BIGINT files_closed - Database files closed monitor element
POOL_ASYNC_DATA_GBP_L_READS BIGINT pool_async_data_gbp_l_reads - Asynchronous group buffer pool data logical reads monitor element
POOL_ASYNC_DATA_GBP_P_READS BIGINT pool_async_data_gbp_p_reads - Asynchronous group buffer pool data physical reads monitor element
POOL_ASYNC_DATA_LBP_PAGES_FOUND BIGINT pool_async_data_lbp_pages_found - Asynchronous local buffer pool data pages found monitor element
POOL_ASYNC_DATA_GBP_INVALID_PAGES BIGINT pool_async_data_gbp_invalid_pages - Asynchronous group buffer pool invalid data pages monitor element
POOL_ASYNC_INDEX_GBP_L_READS BIGINT pool_async_index_gbp_l_reads - Asynchronous group buffer pool index logical reads monitor element
POOL_ASYNC_INDEX_GBP_P_READS BIGINT pool_async_index_gbp_p_reads - Asynchronous group buffer pool index physical reads monitor element
POOL_ASYNC_INDEX_LBP_PAGES_FOUND BIGINT pool_async_index_lbp_pages_found - Asynchronous local buffer pool index pages found monitor element
POOL_ASYNC_INDEX_GBP_INVALID_PAGES BIGINT pool_async_index_gbp_invalid_pages - Asynchronous group buffer pool invalid index pages monitor element
POOL_ASYNC_XDA_GBP_L_READS BIGINT pool_async_xda_gbp_l_reads - Group buffer pool XDA data asynchronous logical read requests monitor element
POOL_ASYNC_XDA_GBP_P_READS BIGINT pool_async_xda_gbp_p_reads - Group buffer pool XDA data asynchronous physical read requests monitor element
POOL_ASYNC_XDA_LBP_PAGES_FOUND BIGINT pool_async_xda_lbp_pages_found - Asynchronous local buffer pool XDA data pages found monitor element
POOL_ASYNC_XDA_GBP_INVALID_PAGES BIGINT pool_async_xda_gbp_invalid_pages - Asynchronous group buffer pool invalid XDA data pages monitor element
POOL_ASYNC_READ_TIME BIGINT pool_async_read_time - Buffer pool asynchronous read time
POOL_ASYNC_WRITE_TIME BIGINT pool_async_write_time - Buffer pool asynchronous write time
SKIPPED_PREFETCH_DATA_P_READS BIGINT skipped_prefetch_data_p_reads - Skipped prefetch data physical reads monitor element
SKIPPED_PREFETCH_INDEX_P_READS BIGINT skipped_prefetch_index_p_reads - Skipped prefetch index physical reads monitor element
SKIPPED_PREFETCH_XDA_P_READS BIGINT skipped_prefetch_xda_p_reads - Skipped prefetch XDA physical reads monitor element
SKIPPED_PREFETCH_TEMP_DATA_P_READS BIGINT skipped_prefetch_temp_data_p_reads - Skipped prefetch temporary data physical reads monitor element
SKIPPED_PREFETCH_TEMP_INDEX_P_READS BIGINT skipped_prefetch_temp_index_p_reads - Skipped prefetch temporary index physical reads monitor element
SKIPPED_PREFETCH_TEMP_XDA_P_READS BIGINT skipped_prefetch_temp_xda_p_reads - Skipped prefetch temporary XDA data physical reads monitor element
SKIPPED_PREFETCH_UOW_DATA_P_READS BIGINT skipped_prefetch_uow_data_p_reads - Skipped prefetch unit of work data physical reads monitor element
SKIPPED_PREFETCH_UOW_INDEX_P_READS BIGINT skipped_prefetch_uow_index_p_reads - Skipped prefetch unit of work index physical reads monitor element
SKIPPED_PREFETCH_UOW_XDA_P_READS BIGINT skipped_prefetch_uow_xda_p_reads - Skipped prefetch unit of work XDA data physical reads monitor element
SKIPPED_PREFETCH_UOW_TEMP_DATA_P_READS BIGINT skipped_prefetch_uow_temp_data_p_reads - Skipped prefetch unit of work temporary data physical reads monitor element
SKIPPED_PREFETCH_UOW_TEMP_INDEX_P_READS BIGINT skipped_prefetch_uow_temp_index_p_reads - Skipped prefetch unit of work temporary index physical reads monitor element
SKIPPED_PREFETCH_UOW_TEMP_XDA_P_READS BIGINT skipped_prefetch_uow_temp_xda_p_reads - Skipped prefetch unit of work temporary XDA data physical reads monitor element
POOL_ASYNC_DATA_GBP_INDEP_PAGES_FOUND_IN_LBP BIGINT pool_async_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found by asynchronous EDUs in a local buffer pool monitor element monitor element
POOL_ASYNC_INDEX_GBP_INDEP_PAGES_FOUND_IN_LBP BIGINT pool_async_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found by asynchronous EDUs in a local buffer pool monitor element monitor element
POOL_ASYNC_XDA_GBP_INDEP_PAGES_FOUND_IN_LBP BIGINT pool_async_xda_gbp_indep_pages_found_in_lbp - Group buffer pool independent XML storage object(XDA) pages found by asynchronous EDUs in a local buffer pool monitor element monitor element
CACHING_TIER VARCHAR(8) Reserved for future use.
CACHING_TIER_IO_ERRORS BIGINT Reserved for future use.
POOL_DATA_CACHING_TIER_L_READS BIGINT Reserved for future use.
POOL_INDEX_CACHING_TIER_L_READS BIGINT Reserved for future use.
POOL_XDA_CACHING_TIER_L_READS BIGINT Reserved for future use.
POOL_COL_CACHING_TIER_L_READS BIGINT Reserved for future use.
POOL_DATA_CACHING_TIER_PAGE_WRITES BIGINT Reserved for future use.
POOL_INDEX_CACHING_TIER_PAGE_WRITES BIGINT Reserved for future use.
POOL_XDA_CACHING_TIER_PAGE_WRITES BIGINT Reserved for future use.
POOL_COL_CACHING_TIER_PAGE_WRITES BIGINT Reserved for future use.
POOL_DATA_CACHING_TIER_PAGE_UPDATES BIGINT Reserved for future use.
POOL_INDEX_CACHING_TIER_PAGE_UPDATES BIGINT Reserved for future use.
POOL_XDA_CACHING_TIER_PAGE_UPDATES BIGINT Reserved for future use.
POOL_COL_CACHING_TIER_PAGE_UPDATES BIGINT Reserved for future use.
POOL_CACHING_TIER_PAGE_READ_TIME BIGINT Reserved for future use.
POOL_CACHING_TIER_PAGE_WRITE_TIME BIGINT Reserved for future use.
POOL_DATA_CACHING_TIER_PAGES_FOUND BIGINT Reserved for future use.
POOL_INDEX_CACHING_TIER_PAGES_FOUND BIGINT Reserved for future use.
POOL_XDA_CACHING_TIER_PAGES_FOUND BIGINT Reserved for future use.
POOL_COL_CACHING_TIER_PAGES_FOUND BIGINT Reserved for future use.
POOL_DATA_CACHING_TIER_GBP_INVALID_PAGES BIGINT Reserved for future use.
POOL_INDEX_CACHING_TIER_GBP_INVALID_PAGES BIGINT Reserved for future use.
POOL_XDA_CACHING_TIER_GBP_INVALID_PAGES BIGINT Reserved for future use.
POOL_COL_CACHING_TIER_GBP_INVALID_PAGES BIGINT Reserved for future use.
POOL_DATA_CACHING_TIER_GBP_INDEP_PAGES_FOUND BIGINT Reserved for future use.
POOL_INDEX_CACHING_TIER_GBP_INDEP_PAGES_FOUND BIGINT Reserved for future use.
POOL_XDA_CACHING_TIER_GBP_INDEP_PAGES_FOUND BIGINT Reserved for future use.
POOL_COL_CACHING_TIER_GBP_INDEP_PAGES_FOUND BIGINT Reserved for future use.
POOL_ASYNC_DATA_CACHING_TIER_READS BIGINT Reserved for future use.
POOL_ASYNC_INDEX_CACHING_TIER_READS BIGINT Reserved for future use.
POOL_ASYNC_XDA_CACHING_TIER_READS BIGINT Reserved for future use.
POOL_ASYNC_COL_CACHING_TIER_READS BIGINT Reserved for future use.
POOL_ASYNC_DATA_CACHING_TIER_PAGE_WRITES BIGINT Reserved for future use.
POOL_ASYNC_INDEX_CACHING_TIER_PAGE_WRITES BIGINT Reserved for future use.
POOL_ASYNC_XDA_CACHING_TIER_PAGE_WRITES BIGINT Reserved for future use.
POOL_ASYNC_COL_CACHING_TIER_PAGE_WRITES BIGINT Reserved for future use.
POOL_ASYNC_DATA_CACHING_TIER_PAGE_UPDATES BIGINT Reserved for future use.
POOL_ASYNC_INDEX_CACHING_TIER_PAGE_UPDATES BIGINT Reserved for future use.
POOL_ASYNC_XDA_CACHING_TIER_PAGE_UPDATES BIGINT Reserved for future use.
POOL_ASYNC_COL_CACHING_TIER_PAGE_UPDATES BIGINT Reserved for future use.
POOL_ASYNC_DATA_CACHING_TIER_PAGES_FOUND BIGINT Reserved for future use.
POOL_ASYNC_INDEX_CACHING_TIER_PAGES_FOUND BIGINT Reserved for future use.
POOL_ASYNC_XDA_CACHING_TIER_PAGES_FOUND BIGINT Reserved for future use.
POOL_ASYNC_COL_CACHING_TIER_PAGES_FOUND BIGINT Reserved for future use.
POOL_ASYNC_DATA_CACHING_TIER_GBP_INVALID_PAGES BIGINT Reserved for future use.
POOL_ASYNC_INDEX_CACHING_TIER_GBP_INVALID_PAGES BIGINT Reserved for future use.
POOL_ASYNC_XDA_CACHING_TIER_GBP_INVALID_PAGES BIGINT Reserved for future use.
POOL_ASYNC_COL_CACHING_TIER_GBP_INVALID_PAGES BIGINT Reserved for future use.
POOL_ASYNC_DATA_CACHING_TIER_GBP_INDEP_PAGES_FOUND BIGINT Reserved for future use.
POOL_ASYNC_INDEX_CACHING_TIER_GBP_INDEP_PAGES_FOUND BIGINT Reserved for future use.
POOL_ASYNC_XDA_CACHING_TIER_GBP_INDEP_PAGES_FOUND BIGINT Reserved for future use.
POOL_ASYNC_COL_CACHING_TIER_GBP_INDEP_PAGES_FOUND BIGINT Reserved for future use.
ROWS_DELETED BIGINT rows_deleted - Rows deleted monitor element
ROWS_INSERTED BIGINT rows_inserted - Rows inserted monitor element
ROWS_UPDATED BIGINT rows_updated - Rows updated monitor element
TOTAL_HASH_JOINS BIGINT total_hash_joins - Total Hash Joins monitor element
TOTAL_HASH_LOOPS BIGINT total_hash_loops - Total Hash Loops monitor element
HASH_JOIN_OVERFLOWS BIGINT hash_join_overflows - Hash Join Overflows monitor element
HASH_JOIN_SMALL_OVERFLOWS BIGINT hash_join_small_overflows - Hash Join Small Overflows monitor element
POST_SHRTHRESHOLD_HASH_JOINS BIGINT post_shrthreshold_hash_joins - Post threshold hash joins monitor element
TOTAL_OLAP_FUNCS BIGINT total_olap_funcs - Total OLAP Functions monitor element
OLAP_FUNC_OVERFLOWS BIGINT olap_func_overflows - OLAP Function Overflows monitor element
DYNAMIC_SQL_STMTS BIGINT dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor element
STATIC_SQL_STMTS BIGINT static_sql_stmts - Static SQL Statements Attempted monitor element
FAILED_SQL_STMTS BIGINT failed_sql_stmts - Failed Statement Operations monitor element
SELECT_SQL_STMTS BIGINT select_sql_stmts - Select SQL Statements Executed monitor element
UID_SQL_STMTS BIGINT uid_sql_stmts - Update/Insert/Delete SQL Statements Executed monitor element
DDL_SQL_STMTS BIGINT ddl_sql_stmts - Data Definition Language (DDL) SQL Statements monitor element
MERGE_SQL_STMTS BIGINT merge_sql_stmts - Merge SQL statements executed
XQUERY_STMTS BIGINT xquery_stmts - XQuery Statements Attempted monitor element
IMPLICIT_REBINDS BIGINT implicit_rebinds - Number of implicit rebinds
BINDS_PRECOMPILES BIGINT binds_precompiles - Binds/Precompiles Attempted monitor element
INT_ROWS_DELETED BIGINT int_rows_deleted - Internal Rows Deleted monitor element
INT_ROWS_INSERTED BIGINT int_rows_inserted - Internal Rows Inserted monitor element
INT_ROWS_UPDATED BIGINT int_rows_updated - Internal Rows Updated monitor element
CALL_SQL_STMTS BIGINT call_sql_stmts - CALL SQL statements executed
POOL_COL_L_READS BIGINT pool_col_l_reads - Buffer pool column-organized logical reads
POOL_TEMP_COL_L_READS BIGINT pool_temp_col_l_reads - Buffer pool column-organized temporary logical reads
POOL_COL_P_READS BIGINT pool_col_p_reads - Buffer pool column-organized physical reads
POOL_TEMP_COL_P_READS BIGINT pool_temp_col_p_reads - Buffer pool column-organized temporary physical reads
POOL_COL_LBP_PAGES_FOUND BIGINT pool_col_lbp_pages_found - Buffer pool column-organized LBP pages found
POOL_COL_WRITES BIGINT pool_col_writes - Buffer pool column-organized writes
POOL_ASYNC_COL_READS BIGINT pool_async_col_reads - Buffer pool asynchronous column-organized reads monitor element
POOL_ASYNC_COL_READ_REQS BIGINT pool_async_col_read_reqs - Buffer pool asynchronous column-organized read requests monitor element
POOL_ASYNC_COL_WRITES BIGINT pool_async_col_writes - Buffer pool asynchronous column-organized writes monitor element
POOL_ASYNC_COL_LBP_PAGES_FOUND BIGINT pool_async_col_lbp_pages_found - Asynchronous local buffer pool column-organized pages found monitor element
POOL_COL_GBP_L_READS BIGINT pool_col_gbp_l_reads - Buffer pool column-organized GBP logical reads
POOL_COL_GBP_P_READS BIGINT pool_col_gbp_p_reads - Buffer pool column-organized GBP physical reads
POOL_COL_GBP_INVALID_PAGES BIGINT pool_col_gbp_invalid_pages - Buffer pool column-organized GBP invalid data pages
POOL_COL_GBP_INDEP_PAGES_FOUND_IN_LBP BIGINT pool_col_gbp_indep_pages_found_in_lbp - Buffer pool column-organized GBP independent pages found in local buffer pool
POOL_ASYNC_COL_GBP_L_READS BIGINT pool_async_col_gbp_l_reads - Asynchronous group buffer pool column-organized logical reads monitor element
POOL_ASYNC_COL_GBP_P_READS BIGINT pool_async_col_gbp_p_reads - Asynchronous group buffer pool column-organized physical reads monitor element
POOL_ASYNC_COL_GBP_INVALID_PAGES BIGINT pool_async_col_gbp_invalid_pages - Asynchronous group buffer pool column-organized invalid data pages monitor element
POOL_ASYNC_COL_GBP_INDEP_PAGES_FOUND_IN_LBP BIGINT pool_async_col_gbp_indep_pages_found_in_lbp - Asynchronous group buffer pool column-organized independent data pages found in local buffer pool monitor element
POOL_QUEUED_ASYNC_COL_REQS BIGINT pool_queued_async_col_reqs - Column-organized prefetch requests
POOL_QUEUED_ASYNC_TEMP_COL_REQS BIGINT pool_queued_async_temp_col_reqs - Column-organized temporary prefetch requests
POOL_QUEUED_ASYNC_COL_PAGES BIGINT pool_queued_async_col_pages - Column-organized page prefetch requests
POOL_QUEUED_ASYNC_TEMP_COL_PAGES BIGINT pool_queued_async_temp_col_pages - Column-organized page temporary prefetch requests
POOL_FAILED_ASYNC_COL_REQS BIGINT pool_failed_async_col_reqs - Failed column-organized prefetch requests
POOL_FAILED_ASYNC_TEMP_COL_REQS BIGINT pool_failed_async_temp_col_reqs - Failed column-organized temporary prefetch requests
SKIPPED_PREFETCH_COL_P_READS BIGINT skipped_prefetch_col_p_reads - Skipped prefetch column-organized physical reads monitor element
SKIPPED_PREFETCH_TEMP_COL_P_READS BIGINT skipped_prefetch_temp_col_p_reads - Skipped prefetch column-organized temporary physical reads monitor element
SKIPPED_PREFETCH_UOW_COL_P_READS BIGINT skipped_prefetch_uow_col_p_reads - Skipped prefetch unit of work column-organized physical reads monitor element
SKIPPED_PREFETCH_UOW_TEMP_COL_P_READS BIGINT skipped_prefetch_uow_temp_col_p_reads - Skipped prefetch unit of work column-organized temporary physical reads monitor element
TOTAL_COL_TIME BIGINT total_col_time - Total column-organized time
TOTAL_COL_PROC_TIME BIGINT total_col_proc_time - Total column-organized processing time
TOTAL_COL_EXECUTIONS BIGINT total_col_executions - Total column-organized executions
NUM_POOLED_AGENTS BIGINT num_pooled_agents - Number of pooled agents monitor element
POST_THRESHOLD_HASH_JOINS BIGINT post_threshold_hash_joins - Hash Join Threshold monitor element
PKG_CACHE_NUM_OVERFLOWS BIGINT pkg_cache_num_overflows - Package Cache Overflows
CAT_CACHE_OVERFLOWS BIGINT cat_cache_overflows - Catalog Cache Overflows
TOTAL_ASYNC_RUNSTATS BIGINT total_async_runstats - Total number of asynchronous RUNSTATS requests
STATS_CACHE_SIZE BIGINT stats_cache_size - Size of statistics cache
TOTAL_HASH_GRPBYS BIGINT total_hash_grpbys - Total hash group by operations
HASH_GRPBY_OVERFLOWS BIGINT hash_grpby_overflows - Hash group by overflows
POST_THRESHOLD_HASH_GRPBYS BIGINT post_threshold_hash_grpbys - Hash group by threshold
ACTIVE_HASH_GRPBYS BIGINT active_hash_grpbys - Active hash group by operations
SORT_HEAP_ALLOCATED BIGINT sort_heap_allocated - Total Sort Heap Allocated monitor element
SORT_SHRHEAP_ALLOCATED BIGINT sort_shrheap_allocated - Sort Share Heap Currently Allocated monitor element
SORT_SHRHEAP_TOP BIGINT sort_shrheap_top - Sort share heap high watermark monitor element
POST_THRESHOLD_OLAP_FUNCS BIGINT post_threshold_olap_funcs - OLAP function threshold monitor element
POST_THRESHOLD_COL_VECTOR_CONSUMERS BIGINT post_threshold_col_vector_consumers - Post threshold columnar_vector consumers
TOTAL_COL_VECTOR_CONSUMERS BIGINT total_col_vector_consumers - Total columnar_vector consumers
ACTIVE_HASH_GRPBYS_TOP BIGINT active_hash_grpbys_top - Active hash Group By operations high watermark
ACTIVE_HASH_JOINS_TOP BIGINT active_hash_joins_top - Active hash joins operations high watermark
ACTIVE_OLAP_FUNCS_TOP BIGINT active_olap_funcs_top - Active OLAP functions operations high watermark
ACTIVE_PEAS BIGINT active_peas - Active partial early aggregations operations
ACTIVE_PEAS_TOP BIGINT active_peas_top - Active partial early aggregations operations high watermark
ACTIVE_PEDS BIGINT active_peds - Active partial early distinct operations
ACTIVE_PEDS_TOP BIGINT active_peds_top - Active partial early distinct operations high watermark
ACTIVE_SORT_CONSUMERS BIGINT active_sort_consumers - Active sort consumers
ACTIVE_SORT_CONSUMERS_TOP BIGINT active_sort_consumers_top - Active sort consumers high watermark
ACTIVE_SORTS_TOP BIGINT active_sorts_top - Active Sorts high watermark
ACTIVE_COL_VECTOR_CONSUMERS BIGINT active_col_vector_consumers - Active columnar_vector consumers
ACTIVE_COL_VECTOR_CONSUMERS_TOP BIGINT active_col_vector_consumers_top - Active columnar_vector consumers high watermark
SORT_CONSUMER_HEAP_TOP BIGINT sort_consumer_heap_top - Individual private sort heap consumer high watermark
SORT_CONSUMER_SHRHEAP_TOP BIGINT sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark
SORT_HEAP_TOP BIGINT sort_heap_top - Sort private heap high watermark
TOTAL_BACKUP_TIME BIGINT total_backup_time - Total elapsed time for online backups
TOTAL_BACKUP_PROC_TIME BIGINT total_backup_proc_time - Total non-wait time for online backups
TOTAL_BACKUPS BIGINT total_backups - Total backups
TOTAL_INDEX_BUILD_TIME BIGINT total_index_build_time - Total time spent building indexes due to index creation
TOTAL_INDEX_BUILD_PROC_TIME BIGINT total_index_build_proc_time - Total non-wait time spent building indexes due to index creation
TOTAL_INDEXES_BUILT BIGINT total_indexes_built - Total number of indexes built
IDA_SEND_WAIT_TIME BIGINT ida_send_wait_time - Time spent waiting to send data monitor element
IDA_SENDS_TOTAL BIGINT ida_sends_total - Number of times data sent monitor element
IDA_SEND_VOLUME BIGINT ida_send_volume - Total data volume sent monitor element
IDA_RECV_WAIT_TIME BIGINT ida_recv_wait_time - Time spent waiting to receive data monitor element
IDA_RECVS_TOTAL BIGINT ida_recvs_total - Number of times data received monitor element
IDA_RECV_VOLUME BIGINT ida_recv_volume - Total data volume received monitor element
FCM_TQ_RECV_WAITS_TOTAL BIGINT fcm_tq_recv_waits_total - Number of times spent waiting to receive the next buffer monitor element
FCM_MESSAGE_RECV_WAITS_TOTAL BIGINT fcm_message_recv_waits_total - Number of times spent waiting for FCM reply message monitor element
FCM_TQ_SEND_WAITS_TOTAL BIGINT fcm_tq_send_waits_total - Number of times spent waiting to send the next buffer monitor element
FCM_MESSAGE_SEND_WAITS_TOTAL BIGINT fcm_message_send_waits_total - Number of times spent blocking on an FCM message send monitor element
FCM_SEND_WAITS_TOTAL BIGINT fcm_send_waits_total - Number of times spent blocking on an FCM send operation monitor element
FCM_RECV_WAITS_TOTAL BIGINT fcm_recv_waits_total - Number of times spent waiting to receive data through FCM monitor element
EXT_TABLE_RECV_WAIT_TIME BIGINT ext_table_recv_wait_time - Total agent wait time for external table readers monitor element
EXT_TABLE_RECVS_TOTAL BIGINT ext_table_recvs_total - Total row batches received from external table readers monitor element
EXT_TABLE_RECV_VOLUME BIGINT ext_table_recv_volume - Total data received from external table readers monitor element
EXT_TABLE_READ_VOLUME BIGINT ext_table_read_volume - Total data read by external table readers monitor element
EXT_TABLE_SEND_WAIT_TIME BIGINT ext_table_send_wait_time - Total agent wait time for external table writers monitor element
EXT_TABLE_SENDS_TOTAL BIGINT ext_table_sends_total - Total row batches sent to external table writers monitor element
EXT_TABLE_SEND_VOLUME BIGINT ext_table_send_volume - Total data sent to external table writers monitor element
EXT_TABLE_WRITE_VOLUME BIGINT ext_table_write_volume - Total data written by external table writers monitor element
COL_VECTOR_CONSUMER_OVERFLOWS BIGINT col_vector_consumer_overflows - Columnar vector consumer overflows monitor element.
TOTAL_COL_SYNOPSIS_TIME BIGINT total_col_synopsis_time - Total column-organized synopsis table time monitor element
TOTAL_COL_SYNOPSIS_PROC_TIME BIGINT total_col_synopsis_proc_time - Total column-organized synopsis table processing time monitor element
TOTAL_COL_SYNOPSIS_EXECUTIONS BIGINT total_col_synopsis_executions - Total column-organized synopsis table executions monitor element
COL_SYNOPSIS_ROWS_INSERTED BIGINT col_synopsis_rows_inserted - Column-organized synopsis table rows inserted monitor element
LOB_PREFETCH_WAIT_TIME BIGINT lob_prefetch_wait_time - LOB prefetch wait time monitor element
LOB_PREFETCH_REQS BIGINT lob_prefetch_reqs - LOB prefetcher request count monitor element
FED_ROWS_DELETED BIGINT fed_rows_deleted - Rows deleted by a federation system monitor element
FED_ROWS_INSERTED BIGINT fed_rows_inserted - Rows inserted by a federation system monitor element
FED_ROWS_UPDATED BIGINT fed_rows_updated - Rows updated by a federation system monitor element
FED_ROWS_READ BIGINT fed_rows_read - Rows read by a federation system monitor element
FED_WAIT_TIME BIGINT fed_wait_time - Time spent by a federation server monitor element
FED_WAITS_TOTAL BIGINT fed_waits_total - Total number of execution times for a federation server monitor element
APPL_SECTION_INSERTS BIGINT appl_section_inserts - Insert count for SQL workspace monitor element
APPL_SECTION_LOOKUPS BIGINT appl_section_lookups - SQL workspace access count monitor element
SHR_WORKSPACE_ACTIVE BIGINT shr_workspace_active - Shared workspace active memory monitor element
SHR_WORKSPACE_INACTIVE BIGINT shr_workspace_inactive - Shared workspace inactive memory monitor element
ADM_OVERFLOWS BIGINT adm_overflows - Number of times an activity fit as an overflow monitor element
ADM_BYPASS_ACT_TOTAL BIGINT adm_bypass_act_total - Number of times admission control was bypassed monitor element
AUTHN_CACHE_LOOKUPS BIGINT ../../com.ibm.db2.luw.admin.mon.doc/doc/monitor-elements-a.html#r_authn_cache_lookups
AUTHN_CACHE_INSERTS BIGINT ../../com.ibm.db2.luw.admin.mon.doc/doc/monitor-elements-a.html#r_authn_cache_inserts
AUTHN_CACHE_HITS BIGINT ../../com.ibm.db2.luw.admin.mon.doc/doc/monitor-elements-a.html#r_authn_cache_hits
AUTHN_CACHE_GROUP_INSERTS BIGINT ../../com.ibm.db2.luw.admin.mon.doc/doc/monitor-elements-a.html#r_authn_cache_group_inserts
AUTHN_CACHE_EXPIRED_EVICTIONS BIGINT ../../com.ibm.db2.luw.admin.mon.doc/doc/monitor-elements-a.html#r_authn_cache_expired_evictions
AUTHN_CACHE_VALID_EVICTIONS BIGINT ../../com.ibm.db2.luw.admin.mon.doc/doc/monitor-elements-a.html#r_authn_cache_valid_evictions
AUTHN_CACHE_MEMORY_USAGE BIGINT ../../com.ibm.db2.luw.admin.mon.doc/doc/monitor-elements-a.html#r_authn_cache_memory_usage
LOW_PRIORITY_ACT_TOTAL BIGINT low_priority_act_total – Total number of low priority activities monitor element
MEDIUM_PRIORITY_ACT_TOTAL BIGINT medium_priority_act_total – Total number of medium priority activities monitor element
HIGH_PRIORITY_ACT_TOTAL BIGINT high_priority_act_total – Total number of high priority activities monitor element
CRITICAL_PRIORITY_ACT_TOTAL BIGINT critical_priority_act_total – Total number of critical priority activities monitor element

Examples

  1. Determine the activation time, activation state, total connections, and connection high water mark for the current database on all members:
    SELECT DB_CONN_TIME, DB_ACTIVATION_STATE, TOTAL_CONS, CONNECTIONS_TOP 
       FROM TABLE (MON_GET_DATABASE(-2));
    This query returns the following output:
    DB_CONN_TIME                DB_ACTIVATION_STATE  TOTAL_CONS  CONNECTIONS_TOP
    --------------------------  -------------------  ----------  ---------------
    2012-09-11-16.31.42.000000  NONE                         23               13
    
  2. Get the explicit hierarchical locking state for the database from all database members.
    SELECT MEMBER,
           DATA_SHARING_REMOTE_LOCKWAIT_COUNT AS DSRL_COUNT,
           DATA_SHARING_REMOTE_LOCKWAIT_TIME AS DSRL_TIME
        FROM TABLE(MON_GET_DATABASE(-2))
    
    The query returns the following output, indicating that one table exited from a "NOT_SHARED" state, taking approximately 10 seconds to do so.
      MEMBER DSRL_COUNT           DSRL_TIME
      ------ -------------------- --------------------
           0                    0                    0
           1                    1                10042
           2                    0                    0