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_DATA_CACHING_TIER_L_READS BIGINT pool_temp_data_caching_tier_l_reads - pool temporary data page caching tier l reads monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_TEMP_DATA_CACHING_TIER_PAGES_FOUND BIGINT pool_temp_data_caching_tier_pages_found - Buffer pool temporary data pages found in caching tier monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_TEMP_INDEX_L_READS BIGINT pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
POOL_TEMP_INDEX_CACHING_TIER_L_READS BIGINT pool_temp_index_caching_tier_l_reads - pool temporary index-type page caching tier l reads monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_TEMP_INDEX_CACHING_TIER_PAGES_FOUND BIGINT pool_temp_index_caching_tier_pages_found - pool temporary index-type tier pages found monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_TEMP_XDA_L_READS BIGINT pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
POOL_TEMP_XDA_CACHING_TIER_L_READS BIGINT pool_temp_xda_caching_tier_l_reads - pool XML data-type page caching tier l reads monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_TEMP_XDA_CACHING_TIER_PAGES_FOUND BIGINT pool_temp_xda_caching_tier_pages_found - pool temporary XML data-type tier pages found monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
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 pool_data_caching_tier_l_reads - pool data caching tier l reads monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_INDEX_CACHING_TIER_L_READS BIGINT pool_index_caching_tier_l_reads - pool index caching tier l reads monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_XDA_CACHING_TIER_L_READS BIGINT pool_xda_caching_tier_l_reads - pool XML data caching tier l reads monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_COL_CACHING_TIER_L_READS BIGINT pool_col_caching_tier_l_reads - pool column data caching tier l reads monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
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 pool_caching_tier_page_read_time - pool caching tier page read time monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_CACHING_TIER_PAGE_WRITE_TIME BIGINT Reserved for future use.
POOL_DATA_CACHING_TIER_PAGES_FOUND BIGINT pool_data_caching_tier_pages_found - Buffer pool data caching tier pages found monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_INDEX_CACHING_TIER_PAGES_FOUND BIGINT pool_index_caching_tier_pages_found - Buffer pool index caching tier pages found monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_XDA_CACHING_TIER_PAGES_FOUND BIGINT pool_xda_caching_tier_pages_found - Buffer pool XML data caching tier pages found monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_COL_CACHING_TIER_PAGES_FOUND BIGINT pool_col_caching_tier_pages_found - Buffer pool columnar-type caching tier pages found monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
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 pool_async_data_caching_tier_reads - Buffer pool asynchronous data-type caching tier page reads
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_ASYNC_INDEX_CACHING_TIER_READS BIGINT pool_async_index_caching_tier_reads - Buffer pool asynchronous index-type caching tier page reads
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_ASYNC_XDA_CACHING_TIER_READS BIGINT pool_async_xda_caching_tier_reads - Buffer pool asynchronous XML data-type caching tier page reads
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_ASYNC_COL_CACHING_TIER_READS BIGINT pool_async_col_caching_tier_reads - Buffer pool asynchronous columnar-type caching tier page reads
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
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 pool_async_data_caching_tier_pages_found - Buffer pool asynchronous data caching tier pages found
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_ASYNC_INDEX_CACHING_TIER_PAGES_FOUND BIGINT pool_async_index_caching_tier_pages_found - Buffer pool asynchronous index caching tier pages found
POOL_ASYNC_XDA_CACHING_TIER_PAGES_FOUND BIGINT pool_async_xda_caching_tier_pages_found - Buffer pool asynchronous XML caching tier pages found
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_ASYNC_COL_CACHING_TIER_PAGES_FOUND BIGINT pool_async_col_caching_tier_pages_found - Buffer pool asynchronous columnar caching tier pages found
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
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_TEMP_COL_CACHING_TIER_L_READS BIGINT pool_temp_col_caching_tier_l_reads - pool temporary columnar-type page caching tier l reads monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
POOL_TEMP_COL_CACHING_TIER_PAGES_FOUND BIGINT pool_temp_col_caching_tier_pages_found - pool temporary columnar-type tier pages found monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
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_CACHING_TIER_PAGE_READ_TIME BIGINT pool_async_caching_tier_page_read_time - Buffer pool caching tier page read time monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
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
CACHING_TIER_DIRECT_READS BIGINT caching_tier_direct_reads - Direct reads from caching tier monitor element
CACHING_TIER_DIRECT_READ_REQS BIGINT caching_tier_direct_read_reqs - Cache direct read requests monitor element
CACHING_TIER_DIRECT_READ_TIME BIGINT caching_tier_direct_read_time - Cache direct read time monitor element
CACHING_TIER_WRITE_BYTES BIGINT caching_tier_write_bytes - Bytes for write requests to local tier monitor element
CACHING_TIER_WRITE_REQS BIGINT caching_tier_write_reqs - Write requests to local cache monitor element
CACHING_TIER_WRITE_TIME BIGINT caching_tier_write_time - Elapsed time for write requests monitor element
COMPACTION_READ_BYTES BIGINT compaction_read_bytes - Bytes read during compaction monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
COMPACTION_READ_REQS BIGINT compaction_read_reqs - Read requests for compaction monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
COMPACTION_READ_TIME BIGINT compaction_read_time - Elapsed time to read during compaction monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
COMPACTION_WRITE_BYTES BIGINT compaction_write_bytes - Bytes written during compaction monitor element
COMPACTION_WRITE_REQS BIGINT compaction_write_reqs - Write request during compaction monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
COMPACTION_WRITE_TIME BIGINT compaction_write_time - Elapsed time to write during compaction monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
LOCAL_TIER_WRITE_BYTES BIGINT local_tier_write_bytes - Bytes to write to local tier monitor element
LOCAL_TIER_WRITE_REQS BIGINT local_tier_write_reqs - Write request for local tier monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
LOCAL_TIER_WRITE_TIME BIGINT local_tier_write_time - Elapsed time to write monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
REMOTE_STORAGE_TIER_WRITE_BYTES BIGINT remote_storage_tier_write_bytes - Bytes to write to remote storage tier monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
REMOTE_STORAGE_TIER_WRITE_REQS BIGINT remote_storage_tier_write_reqs - Write requests to remote storage monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
REMOTE_STORAGE_TIER_WRITE_TIME BIGINT remote_storage_tier_write_time - Elapsed time to write to remote storage monitor element
Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.

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