DB2 10.5 for Linux, UNIX, and Windows

MON_GET_DATABASE_DETAILS table function - Get database metrics as an XML document

The MON_GET_DATABASE_DETAILS table function retrieves database metrics and returns the information in an XML document.

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 diagram
>>-MON_GET_DATABASE_DETAILS--(--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 a database that is available for connection and use by applications.

Information returned

Table 1. Information returned by the MON_GET_DATABASE_DETAILS routine
Column name Data type Description
MEMBER SMALLINT member- Database member
DETAILS BLOB(1M) XML document that contains activity details. See Table 2 for a description of the elements in this document.

Detailed metrics returned

Table 2. Detailed metrics returned for MON_GET_DATABASE_DETAILS
Element name Data type Description or corresponding monitor element
act_aborted_total xs:long act_aborted_total - Total aborted activities monitor element
act_completed_total xs:long act_completed_total - Total completed activities monitor element
act_rejected_total xs:long act_rejected_total - Total rejected activities monitor element
act_rqsts_total xs:long act_rqsts_total - Total activity requests monitor elements
active_col_vector_consumers_top xs:long active_col_vector_consumers_top - Active columnar_vector consumers high watermark
active_col_vector_consumers xs:long active_col_vector_consumers - Active columnar_vector consumers
active_hash_grpbys_top xs:long active_hash_grpbys_top - Active hash Group By operations high watermark
active_hash_grpbys xs:long active_hash_grpbys - Active hash group by operations
active_hash_joins_top xs:long active_hash_joins_top - Active hash joins operations high watermark
active_hash_joins xs:long active_hash_joins - Active hash joins monitor element
active_olap_funcs_top xs:long active_olap_funcs_top - Active OLAP functions operations high watermark
active_olap_funcs xs:long active_olap_funcs - Active OLAP Functions monitor element
active_peas_top xs:long active_peas_top - Active partial early aggregations operations high watermark
active_peas xs:long active_peas - Active partial early aggregations operations
active_peds_top xs:long active_peds_top - Active partial early distinct operations high watermark
active_peds xs:long active_peds - Active partial early distinct operations
active_sort_consumers_top xs:long active_sort_consumers_top - Active sort consumers high watermark
active_sort_consumers xs:long active_sort_consumers - Active sort consumers
active_sorts_top xs:long active_sorts_top - Active Sorts high watermark
active_sorts xs:long active_sorts - Active Sorts monitor element
agent_wait_time xs:long agent_wait_time - Agent wait time monitor element
agent_waits_total xs:long agent_waits_total - Total agent waits monitor element
agents_top xs:long agents_top - Number of Agents Created monitor element
app_act_aborted_total xs:long app_act_aborted_total - Total failed external coordinator activities monitor element
app_act_completed_total xs:long app_act_completed_total - Total successful external coordinator activities monitor element
app_act_rejected_total xs:long app_act_rejected_total - Total rejected external coordinator activities monitor element
app_rqsts_completed_total xs:long app_rqsts_completed_total - Total application requests completed monitor element
appls_cur_cons xs:long appls_cur_cons - Applications Connected Currently monitor element
appls_in_db2 xs:long appls_in_db2 - Applications Executing in the Database Currently monitor element
audit_events_total xs:long audit_events_total - Total audit events monitor element
audit_file_write_wait_time xs:long audit_file_write_wait_time - Audit file write wait time monitor element
audit_file_writes_total xs:long audit_file_writes_total - Total audit files written monitor element
audit_subsystem_wait_time xs:long audit_subsystem_wait_time - Audit subsystem wait time monitor element
audit_subsystem_waits_total xs:long audit_subsystem_waits_total - Total audit subsystem waits monitor element
binds_precompiles xs:long binds_precompiles - Binds/Precompiles Attempted monitor element
block_ios xs:long block_ios - Number of block I/O requests monitor element
call_sql_stmts xs:long call_sql_stmts - CALL SQL statements executed
cat_cache_inserts xs:long cat_cache_inserts - Catalog cache inserts monitor element
cat_cache_lookups xs:long cat_cache_lookups - Catalog cache lookups monitor element
cat_cache_overflows xs:long cat_cache_overflows - Catalog Cache Overflows
catalog_partition xs:short catalog_node - Catalog Node Number
cf_wait_time xs:long cf_wait_time - cluster caching facility wait time monitor element
cf_waits xs:long cf_waits - Number of cluster caching facility waits monitor element
client_idle_wait_time xs:long client_idle_wait_time - Client idle wait time monitor element
comm_exit_wait_time xs:long comm_exit_wait_time - Communication buffer exit wait time monitor element
comm_exit_waits xs:long comm_exit_waits - Communication buffer exit number of waits monitor element
connections_top xs:long connections_top - Maximum Number of Concurrent Connections monitor element
coord_agents_top xs:long coord_agents_top - Maximum Number of Coordinating Agents monitor element
data_sharing_remote_lockwait_count xs:long data_sharing_remote_lockwait_count - Data sharing remote lock wait count monitor element
data_sharing_remote_lockwait_time xs:long data_sharing_remote_lockwait_time - Data sharing remote lock wait time monitor element
db_activation_state xs:db2_string_type_10 db_activation_state - Database activation state
db_conn_time xs:dateTime db_conn_time - Database activation timestamp monitor element
db_path xs:long db_path - Database Path monitor element
db_status xs:db2_string_type_16 db_status - Status of database monitor element
ddl_sql_stmts xs:long ddl_sql_stmts - Data Definition Language (DDL) SQL Statements monitor element
deadlocks xs:long deadlocks - Deadlocks detected monitor element
diaglog_write_wait_time xs:long diaglog_write_wait_time - Diagnostic log file write wait time monitor element
diaglog_writes_total xs:long diaglog_writes_total - Total diagnostic log file writes monitor element
direct_read_reqs xs:long direct_read_reqs - Direct read requests monitor element
direct_read_time xs:long direct_read_time - Direct read time monitor element
direct_reads xs:long direct_reads - Direct reads from database monitor element
direct_write_reqs xs:long direct_write_reqs - Direct write requests monitor element
direct_write_time xs:long direct_write_time - Direct write time monitor element
direct_writes xs:long direct_writes - Direct writes to database monitor element
disabled_peds xs:long disabled_peds - Disabled partial early distincts monitor element
dynamic_sql_stmts xs:long dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor element
evmon_wait_time xs:long evmon_wait_time - Event monitor wait time monitor element
evmon_waits_total xs:long evmon_waits_total - Event monitor total waits monitor element
failed_sql_stmts xs:long failed_sql_stmts - Failed Statement Operations monitor element
fcm_message_recv_volume xs:long fcm_message_recv_volume - FCM message received volume monitor element
fcm_message_recv_wait_time xs:long fcm_message_recv_wait_time - FCM message received wait time monitor element
fcm_message_recv_waits_total xs:nonNegativeInteger fcm_message_recv_waits_total - Number of times spent waiting for FCM reply message monitor element
fcm_message_recvs_total xs:long fcm_message_recvs_total - Total FCM message receives monitor element
fcm_message_send_volume xs:long fcm_message_send_volume - FCM message send volume monitor element
fcm_message_send_wait_time xs:long fcm_message_send_wait_time - FCM message send wait time monitor element
fcm_message_send_waits_total xs:nonNegativeInteger fcm_message_send_waits_total - Number of times spent blocking on an FCM message send monitor element
fcm_message_sends_total xs:long fcm_message_sends_total - Total FCM message sends monitor element
fcm_recv_volume xs:long fcm_recv_volume - FCM received volume monitor element
fcm_recv_wait_time xs:long fcm_recv_wait_time - FCM received wait time monitor element
fcm_recv_waits_total xs:nonNegativeInteger fcm_recv_waits_total - Number of times spent waiting to receive data through FCM monitor element
fcm_recvs_total xs:long fcm_recvs_total - FCM receives total monitor element
fcm_send_volume xs:long fcm_send_volume - FCM send volume monitor element
fcm_send_wait_time xs:long fcm_send_wait_time - FCM send wait time monitor element
fcm_send_waits_total xs:nonNegativeInteger fcm_send_waits_total - Number of times spent blocking on an FCM send operation monitor element
fcm_sends_total xs:long fcm_sends_total - FCM sends total monitor element
fcm_tq_recv_volume xs:long fcm_tq_recv_volume - FCM table queue received volume monitor element
fcm_tq_recv_wait_time xs:long fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
fcm_tq_recv_waits_total xs:nonNegativeInteger fcm_tq_recv_waits_total - Number of times spent waiting to receive the next buffer monitor element
fcm_tq_recvs_total xs:long fcm_tq_recvs_total - FCM table queue receives total monitor element
fcm_tq_send_volume xs:long fcm_tq_send_volume - FCM table queue send volume monitor element
fcm_tq_send_wait_time xs:long fcm_tq_send_wait_time - FCM table queue send wait time monitor element
fcm_tq_send_waits_total xs:nonNegativeInteger fcm_tq_send_waits_total - Number of times spent waiting to send the next buffer monitor element
fcm_tq_sends_total xs:long fcm_tq_sends_total - FCM table queue send total monitor element
files_closed xs:long files_closed - Database files closed monitor element
hash_grpby_overflows xs:long hash_grpby_overflows - Hash group by overflows
hash_join_overflows xs:long hash_join_overflows - Hash Join Overflows monitor element
hash_join_small_overflows xs:long hash_join_small_overflows - Hash Join Small Overflows monitor element
ida_recv_volume xs:long ida_recv_volume - Total data volume received monitor element
ida_recv_wait_time xs:long ida_recv_wait_time - Time spent waiting to receive data monitor element
ida_recvs_total xs:long ida_recvs_total - Number of times data received monitor element
ida_send_volume xs:long ida_send_volume - Total data volume sent monitor element
ida_send_wait_time xs:long ida_send_wait_time - Time spent waiting to send data monitor element
ida_sends_total xs:long ida_sends_total - Number of times data sent monitor element
int_commits xs:long int_commits - Internal commits monitor element
int_rollbacks xs:long int_rollbacks - Internal rollbacks monitor element
int_rows_deleted xs:long int_rows_deleted - Internal Rows Deleted monitor element
int_rows_inserted xs:long int_rows_inserted - Internal Rows Inserted monitor element
int_rows_updated xs:long int_rows_updated - Internal Rows Updated monitor element
ipc_recv_volume xs:long ipc_recv_volume - Interprocess communication received volume monitor element
ipc_recv_wait_time xs:long ipc_recv_wait_time - Interprocess communication received wait time monitor element
ipc_recvs_total xs:long ipc_recvs_total - Interprocess communication receives total monitor element
ipc_send_volume xs:long ipc_send_volume - Interprocess communication send volume monitor element
ipc_send_wait_time xs:long ipc_send_wait_time - Interprocess communication send wait time monitor element
ipc_sends_total xs:long ipc_sends_total - Interprocess communication send total monitor element
last_backup xs:dateTime last_backup - Last Backup Timestamp monitor element
lock_escals_global xs:long lock_escals_global - Number of global lock escalations monitor element
lock_escals_locklist xs:long lock_escals_locklist - Number of locklist lock escalations monitor element
lock_escals_maxlocks xs:long lock_escals_maxlocks - Number of maxlocks lock escalations monitor element
lock_escals xs:long lock_escals - Number of lock escalations monitor element
lock_list_in_use xs:long lock_list_in_use - Total lock list memory in use monitor element
lock_timeouts_global xs:long lock_timeouts_global - Lock timeouts global monitor element
lock_timeouts xs:long lock_timeouts - Number of lock timeouts monitor element
lock_wait_time_global xs:long lock_wait_time_global - Lock wait time global monitor element
lock_wait_time xs:long lock_wait_time - Time waited on locks monitor element
lock_waits_global xs:long lock_waits_global - Lock waits global monitor element
locks_waiting xs:long locks_waiting - Current agents waiting on locks monitor element
log_buffer_wait_time xs:long log_buffer_wait_time - Log buffer wait time monitor element
log_disk_wait_time xs:long log_disk_wait_time - Log disk wait time monitor element
log_disk_waits_total xs:long log_disk_waits_total - Total log disk waits monitor element
implicit_rebinds xs:long implicit_rebinds - Number of implicit rebinds
member xs:short member - Database member monitor element
merge_sql_stmts xs:long merge_sql_stmts - Merge SQL statements executed
num_assoc_agents xs:long num_assoc_agents - Number of Associated Agents monitor element
num_coord_agents xs:long num_coord_agents - Number of coordinator agents
num_locks_held xs:long locks_held - Locks held monitor
num_locks_waiting xs:long lock_waits - Lock waits
num_log_buffer_full xs:long num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
num_lw_thresh_exceeded xs:long num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
num_pooled_agents xs:long num_pooled_agents - Number of pooled agents monitor element
olap_func_overflows xs:long olap_func_overflows - OLAP Function Overflows monitor element
pages_from_block_ios xs:long pages_from_block_ios - Total number of pages read by block I/O monitor element
pages_from_vectored_ios xs:long pages_from_vectored_ios - Total number of pages read by vectored I/O monitor element
pkg_cache_inserts xs:long pkg_cache_inserts - Package cache inserts monitor element
pkg_cache_lookups xs:long pkg_cache_lookups - Package cache lookups monitor element
pkg_cache_num_overflows xs:long pkg_cache_num_overflows - Package Cache Overflows
pool_async_col_gbp_indep_pages_found_in_lbp xs:nonNegativeInteger 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_async_col_gbp_invalid_pages xs:nonNegativeInteger pool_async_col_gbp_invalid_pages - Asynchronous group buffer pool column-organized invalid data pages monitor element
pool_async_col_gbp_l_reads xs:nonNegativeInteger pool_async_col_gbp_l_reads - Asynchronous group buffer pool column-organized logical reads monitor element
pool_async_col_gbp_p_reads xs:nonNegativeInteger pool_async_col_gbp_p_reads - Asynchronous group buffer pool column-organized physical reads monitor element
pool_async_col_lbp_pages_found xs:nonNegativeInteger pool_async_col_lbp_pages_found - Asynchronous local buffer pool column-organized pages found monitor element
pool_async_col_read_reqs xs:nonNegativeInteger pool_async_col_read_reqs - Buffer pool asynchronous column-organized read requests monitor element
pool_async_col_reads xs:nonNegativeInteger pool_async_col_reads - Buffer pool asynchronous column-organized reads monitor element
pool_async_col_writes xs:nonNegativeInteger pool_async_col_writes - Buffer pool asynchronous column-organized writes monitor element
pool_async_data_gbp_indep_pages_found_in_lbp xs:long 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_data_gbp_invalid_pages xs:long pool_async_data_gbp_invalid_pages - Asynchronous group buffer pool invalid data pages monitor element
pool_async_data_gbp_l_reads xs:long pool_async_data_gbp_l_reads - Asynchronous group buffer pool data logical reads monitor element
pool_async_data_gbp_p_reads xs:long pool_async_data_gbp_p_reads - Asynchronous group buffer pool data physical reads monitor element
pool_async_data_lbp_pages_found xs:long pool_async_data_lbp_pages_found - Asynchronous local buffer pool data pages found monitor element
pool_async_data_read_reqs xs:long pool_async_data_read_reqs - Buffer pool asynchronous read requests monitor element
pool_async_data_reads xs:long pool_async_data_reads - Buffer pool asynchronous data reads monitor element
pool_async_data_writes xs:long pool_async_data_writes - Buffer pool asynchronous data writes monitor element
pool_async_index_gbp_indep_pages_found_in_lbp xs:long 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_index_gbp_invalid_pages xs:long pool_async_index_gbp_invalid_pages - Asynchronous group buffer pool invalid index pages monitor element
pool_async_index_gbp_l_reads xs:long pool_async_index_gbp_l_reads - Asynchronous group buffer pool index logical reads monitor element
pool_async_index_gbp_p_reads xs:long pool_async_index_gbp_p_reads - Asynchronous group buffer pool index physical reads monitor element
pool_async_index_lbp_pages_found xs:long pool_async_index_lbp_pages_found - Asynchronous local buffer pool index pages found monitor element
pool_async_index_read_reqs xs:long pool_async_index_read_reqs - Buffer pool asynchronous index read requests monitor element
pool_async_index_reads xs:long pool_async_index_reads - Buffer pool asynchronous index reads monitor element
pool_async_index_writes xs:long pool_async_index_writes - Buffer pool asynchronous index writes monitor element
pool_async_read_time xs:long pool_async_read_time - Buffer Pool Asynchronous Read Time monitor element
pool_async_write_time xs:long pool_async_write_time - Buffer pool asynchronous write time monitor element
pool_async_xda_gbp_indep_pages_found_in_lbp xs:long 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
pool_async_xda_gbp_invalid_pages xs:long pool_async_xda_gbp_invalid_pages - Asynchronous group buffer pool invalid XDA data pages monitor element
pool_async_xda_gbp_l_reads xs:long pool_async_xda_gbp_l_reads - Group buffer pool XDA data asynchronous logical read requests monitor element
pool_async_xda_gbp_p_reads xs:long pool_async_xda_gbp_p_reads - Group buffer pool XDA data asynchronous physical read requests monitor element
pool_async_xda_lbp_pages_found xs:long pool_async_xda_lbp_pages_found - Asynchronous local buffer pool XDA data pages found monitor element
pool_async_xda_read_reqs xs:long pool_async_xda_read_reqs - Buffer pool asynchronous XDA read requests monitor element
pool_async_xda_reads xs:long pool_async_xda_reads - Buffer pool asynchronous XDA data reads monitor element
pool_async_xda_writes xs:long pool_async_xda_writes - Buffer pool asynchronous XDA data writes monitor element
pool_col_gbp_indep_pages_found_in_lbp xs:nonNegativeInteger pool_col_gbp_indep_pages_found_in_lbp - Buffer pool column-organized GBP independent pages found in local buffer pool
pool_col_gbp_invalid_pages xs:nonNegativeInteger pool_col_gbp_invalid_pages - Buffer pool column-organized GBP invalid data pages
pool_col_gbp_l_reads xs:nonNegativeInteger pool_col_gbp_l_reads - Buffer pool column-organized GBP logical reads
pool_col_gbp_p_reads xs:nonNegativeInteger pool_col_gbp_p_reads - Buffer pool column-organized GBP physical reads
pool_col_l_reads xs:nonNegativeInteger pool_col_l_reads - Buffer pool column-organized logical reads
pool_col_lbp_pages_found xs:nonNegativeInteger pool_col_lbp_pages_found - Buffer pool column-organized LBP pages found
pool_col_p_reads xs:nonNegativeInteger pool_col_p_reads - Buffer pool column-organized physical reads
pool_col_writes xs:nonNegativeInteger pool_col_writes - Buffer pool column-organized writes
pool_data_gbp_indep_pages_found_in_lbp xs:long pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool monitor element
pool_data_gbp_invalid_pages xs:long pool_data_gbp_invalid_pages - Group buffer pool invalid data pages monitor element
pool_data_gbp_l_reads xs:long pool_data_gbp_l_reads - Group buffer pool data logical reads monitor element
pool_data_gbp_p_reads xs:long pool_data_gbp_p_reads - Group buffer pool data physical reads monitor element
pool_data_l_reads xs:long pool_data_l_reads - Buffer pool data logical reads monitor element
pool_data_lbp_pages_found xs:long pool_data_lbp_pages_found - Local buffer pool found data pages monitor element
pool_data_p_reads xs:long pool_data_p_reads - Buffer pool data physical reads monitor element
pool_data_writes xs:long pool_data_writes - Buffer pool data writes monitor element
pool_drty_pg_steal_clns xs:long pool_drty_pg_steal_clns - Buffer pool victim page cleaners triggered monitor element
pool_drty_pg_thrsh_clns xs:long pool_drty_pg_thrsh_clns - Buffer pool threshold cleaners triggered monitor element
pool_failed_async_col_reqs xs:nonNegativeInteger pool_failed_async_col_reqs - Failed column-organized prefetch requests
pool_failed_async_data_reqs xs:long pool_failed_async_data_reqs - Failed data prefetch requests monitor element
pool_failed_async_index_reqs xs:long pool_failed_async_index_reqs - Failed index prefetch requests monitor element
pool_failed_async_other_reqs xs:long pool_failed_async_other_reqs - Failed non-prefetch requests monitor element
pool_failed_async_temp_col_reqs xs:nonNegativeInteger pool_failed_async_temp_col_reqs - Failed column-organized temporary prefetch requests
pool_failed_async_temp_data_reqs xs:long pool_failed_async_temp_data_reqs - Failed data prefetch requests for temporary table spaces monitor element
pool_failed_async_temp_index_reqs xs:long pool_failed_async_temp_index_reqs - Failed index prefetch requests for temporary table spaces monitor element
pool_failed_async_temp_xda_reqs xs:long pool_failed_async_temp_xda_reqs - Failed XDA prefetch requests for temporary table spaces monitor element
pool_failed_async_xda_reqs xs:long pool_failed_async_xda_reqs - Failed XDA prefetch requests monitor element
pool_index_gbp_indep_pages_found_in_lbp xs:long pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool monitor element
pool_index_gbp_invalid_pages xs:long pool_index_gbp_invalid_pages - Group buffer pool invalid index pages monitor element
pool_index_gbp_l_reads xs:long pool_index_gbp_l_reads - Group buffer pool index logical reads monitor element
pool_index_gbp_p_reads xs:long pool_index_gbp_p_reads - Group buffer pool index physical reads monitor elements
pool_index_l_reads xs:long pool_index_l_reads - Buffer pool index logical reads monitor element
pool_index_lbp_pages_found xs:long pool_index_lbp_pages_found - Local buffer pool index pages found monitor element
pool_index_p_reads xs:long pool_index_p_reads - Buffer pool index physical reads monitor element
pool_index_writes xs:long pool_index_writes - Buffer pool index writes monitor element
pool_lsn_gap_clns xs:long pool_lsn_gap_clns - Buffer pool log space cleaners triggered monitor element
pool_no_victim_buffer xs:long pool_no_victim_buffer - Buffer pool no victim buffers monitor element
pool_queued_async_col_pages xs:nonNegativeInteger pool_queued_async_col_pages - Column-organized page prefetch requests
pool_queued_async_col_reqs xs:nonNegativeInteger pool_queued_async_col_reqs - Column-organized prefetch requests
pool_queued_async_data_pages xs:long pool_queued_async_data_pages - Data pages prefetch requests monitor element
pool_queued_async_data_reqs xs:long pool_queued_async_data_reqs - Data prefetch requests monitor element
pool_queued_async_index_pages xs:long pool_queued_async_index_pages - Index pages prefetch requests monitor element
pool_queued_async_index_reqs xs:long pool_queued_async_index_reqs - Index prefetch requests monitor element
pool_queued_async_other_reqs xs:long pool_queued_async_other_reqs - Other requests handled by prefetchers monitor element
pool_queued_async_temp_col_pages xs:nonNegativeInteger pool_queued_async_temp_col_pages - Column-organized page temporary prefetch requests
pool_queued_async_temp_col_reqs xs:nonNegativeInteger pool_queued_async_temp_col_reqs - Column-organized temporary prefetch requests
pool_queued_async_temp_data_pages xs:long pool_queued_async_temp_data_pages - Data pages prefetch requests for temporary table spaces monitor element
pool_queued_async_temp_data_reqs xs:long pool_queued_async_temp_data_reqs - Data prefetch requests for temporary table spaces monitor element
pool_queued_async_temp_index_pages xs:long pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
pool_queued_async_temp_index_reqs xs:long pool_queued_async_temp_index_reqs - Index prefetch requests for temporary table spaces monitor element
pool_queued_async_temp_xda_pages xs:long pool_queued_async_temp_xda_pages - XDA data pages prefetch requests for temporary table spaces monitor element
pool_queued_async_temp_xda_reqs xs:long pool_queued_async_temp_xda_reqs - XDA data prefetch requests for temporary table spaces monitor element
pool_queued_async_xda_pages xs:long pool_queued_async_xda_pages - XDA pages prefetch requests monitor element
pool_queued_async_xda_reqs xs:long pool_queued_async_xda_reqs - XDA prefetch requests monitor element
pool_read_time xs:long pool_read_time - Total buffer pool physical read time monitor element
pool_temp_col_l_reads xs:nonNegativeInteger pool_temp_col_l_reads - Buffer pool column-organized temporary logical reads
pool_temp_col_p_reads xs:nonNegativeInteger pool_temp_col_p_reads - Buffer pool column-organized temporary physical reads
pool_temp_data_l_reads xs:long pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
pool_temp_data_p_reads xs:long pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
pool_temp_index_l_reads xs:long pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
pool_temp_index_p_reads xs:long pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
pool_temp_xda_l_reads xs:long pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
pool_temp_xda_p_reads xs:long pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
pool_write_time xs:long pool_write_time - Total buffer pool physical write time monitor element
pool_xda_gbp_indep_pages_found_in_lbp xs:long pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool monitor element
pool_xda_gbp_invalid_pages xs:long pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages monitor element
pool_xda_gbp_l_reads xs:long pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests monitor element
pool_xda_gbp_p_reads xs:long pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests monitor element
pool_xda_l_reads xs:long pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
pool_xda_lbp_pages_found xs:long pool_xda_lbp_pages_found - Local buffer pool XDA data pages found monitor element
pool_xda_p_reads xs:long pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
pool_xda_writes xs:long pool_xda_writes - Buffer pool XDA data writes monitor element
post_shrthreshold_hash_joins xs:long post_shrthreshold_hash_joins - Post threshold hash joins monitor element
post_shrthreshold_sorts xs:long post_shrthreshold_sorts - Post shared threshold sorts monitor element
post_threshold_col_vector_consumers xs:long post_threshold_col_vector_consumers - Post threshold columnar_vector consumers
post_threshold_hash_grpbys xs:long post_threshold_hash_grpbys - Hash group by threshold monitor element
post_threshold_hash_joins xs:long post_threshold_hash_joins - Hash Join Threshold monitor element
post_threshold_olap_funcs xs:long post_threshold_olap_funcs - OLAP function threshold monitor element
post_threshold_peas xs:long post_threshold_peas - Partial early aggregation threshold monitor element
post_threshold_peds xs:long post_threshold_peds - Partial early distincts threshold monitor element
post_threshold_sorts xs:long post_threshold_sorts - Post threshold sorts monitor element
prefetch_wait_time xs:long prefetch_wait_time - Time waited for prefetch monitor element
prefetch_waits xs:long prefetch_waits - Prefetcher wait count monitor element
reclaim_wait_time xs:long reclaim_wait_time - Reclaim wait time monitor element
rows_deleted xs:long rows_deleted - Rows deleted monitor element
rows_inserted xs:long rows_inserted - Rows inserted monitor element
rows_modified xs:long rows_modified - Rows modified monitor element
rows_read xs:long rows_read - Rows read monitor element
rows_returned xs:long rows_returned - Rows returned monitor element
rows_updated xs:long rows_updated - Rows updated monitor element
rqsts_completed_total xs:long rqsts_completed_total - Total requests completed monitor element
select_sql_stmts xs:long select_sql_stmts - Select SQL Statements Executed monitor element
skipped_prefetch_col_p_reads xs:nonNegativeInteger skipped_prefetch_col_p_reads - Skipped prefetch column-organized physical reads monitor element
skipped_prefetch_data_p_reads xs:long skipped_prefetch_data_p_reads - Skipped prefetch data physical reads monitor element
skipped_prefetch_index_p_reads xs:long skipped_prefetch_index_p_reads - Skipped prefetch index physical reads monitor element
skipped_prefetch_temp_col_p_reads xs:nonNegativeInteger skipped_prefetch_temp_col_p_reads - Skipped prefetch column-organized temporary physical reads monitor element
skipped_prefetch_temp_data_p_reads xs:long skipped_prefetch_temp_data_p_reads - Skipped prefetch temporary data physical reads monitor element
skipped_prefetch_temp_index_p_reads xs:long skipped_prefetch_temp_index_p_reads - Skipped prefetch temporary index physical reads monitor element
skipped_prefetch_temp_xda_p_reads xs:long skipped_prefetch_temp_xda_p_reads - Skipped prefetch temporary XDA data physical reads monitor element
skipped_prefetch_uow_col_p_reads xs:nonNegativeInteger skipped_prefetch_uow_col_p_reads - Skipped prefetch unit of work column-organized physical reads monitor element
skipped_prefetch_uow_data_p_reads xs:long skipped_prefetch_uow_data_p_reads - Skipped prefetch unit of work data physical reads monitor element
skipped_prefetch_uow_index_p_reads xs:long skipped_prefetch_uow_index_p_reads - Skipped prefetch unit of work index physical reads monitor element
skipped_prefetch_uow_temp_col_p_reads xs:nonNegativeInteger skipped_prefetch_uow_temp_col_p_reads - Skipped prefetch unit of work column-organized temporary physical reads monitor element
skipped_prefetch_uow_temp_data_p_reads xs:long 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 xs:long 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 xs:long skipped_prefetch_uow_temp_xda_p_reads - Skipped prefetch unit of work temporary XDA data physical reads monitor element
skipped_prefetch_uow_xda_p_reads xs:long skipped_prefetch_uow_xda_p_reads - Skipped prefetch unit of work XDA data physical reads monitor element
skipped_prefetch_xda_p_reads xs:long skipped_prefetch_xda_p_reads - Skipped prefetch XDA physical reads monitor element
sort_consumer_heap_top xs:long sort_consumer_heap_top - Individual private sort heap consumer high watermark
sort_consumer_shrheap_top xs:long sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark
sort_heap_allocated xs:long sort_heap_allocated - Total Sort Heap Allocated monitor element
sort_heap_top xs:long sort_heap_top - Sort private heap high watermark
sort_overflows xs:long sort_overflows - Sort overflows monitor element
sort_shrheap_allocated xs:long sort_shrheap_allocated - Sort Share Heap Currently Allocated monitor element
sort_shrheap_top xs:long sort_shrheap_top - Sort share heap high watermark monitor element
spacemappage_reclaim_wait_time xs:long spacemappage_reclaim_wait_time - Space map page reclaim wait time monitor element
static_sql_stmts xs:long static_sql_stmts - Static SQL Statements Attempted monitor element
stats_cache_size xs:long stats_cache_size - Size of statistics cache
tcpip_recv_volume xs:long tcpip_recv_volume - TCP/IP received volume monitor element
tcpip_recv_wait_time xs:long tcpip_recv_wait_time - TCP/IP received wait time monitor element
tcpip_recvs_total xs:long tcpip_recvs_total - TCP/IP receives total monitor element
tcpip_send_volume xs:long tcpip_send_volume - TCP/IP send volume monitor element
tcpip_send_wait_time xs:long tcpip_send_wait_time - TCP/IP send wait time monitor element
tcpip_sends_total xs:long tcpip_sends_total - TCP/IP sends total monitor element
thresh_violations xs:long thresh_violations - Number of threshold violations monitor element
total_act_time xs:long total_act_time - Total activity time monitor element
total_act_wait_time xs:long total_act_wait_time - Total activity wait time monitor element
total_app_commits xs:long total_app_commits - Total application commits monitor elements
total_app_rollbacks xs:long total_app_rollbacks - Total application rollbacks monitor element
total_app_rqst_time xs:long total_app_rqst_time - Total application request time monitor element
total_app_section_executions xs:long total_app_section_executions - Total application section executions monitor element
total_async_runstats xs:long total_async_runstats - Total number of asynchronous RUNSTATS requests
total_backup_proc_time xs:long total_backup_proc_time - Total non-wait time for online backups
total_backup_time xs:long total_backup_time - Total elapsed time for online backups
total_backups xs:long total_backups - Total backups
total_col_executions xs:nonNegativeInteger total_col_executions - Total column-organized executions
total_col_proc_time xs:nonNegativeInteger total_col_proc_time - Total column-organized processing time
total_col_time xs:nonNegativeInteger total_col_time - Total column-organized time
total_col_vector_consumers xs:long total_col_vector_consumers - Total columnar_vector consumers
total_commit_proc_time xs:long total_commit_proc_time - Total commits processing time monitor element
total_commit_time xs:long total_commit_time - Total commit time monitor element
total_compilations xs:long total_compilations - Total compilations monitor element
total_compile_proc_time xs:long total_compile_proc_time - Total compile processing time monitor element
total_compile_time xs:long total_compile_time - Total compile time monitor element
total_connect_authentication_proc_time xs:long total_connect_authentication_proc_time - Total connection authentication processing time monitor element
total_connect_authentication_time xs:long total_connect_authentication_time - Total connection or switch user authentication request time monitor element
total_connect_authentications xs:long total_connect_authentications - Connections or switch user authentications performed monitor element
total_connect_request_proc_time xs:long total_connect_request_proc_time - Total connection or switch user request processing time monitor element
total_connect_request_time xs:long total_connect_request_time - Total connection or switch user request time monitor element
total_connect_requests xs:long total_connect_requests - Connection or switch user requests monitor element
total_cons xs:long total_cons - Connects Since Database Activation monitor element
total_cpu_time xs:long total_cpu_time - Total CPU time monitor element
total_disp_run_queue_time xs:long total_disp_run_queue_time - Total dispatcher run queue time monitor element
total_extended_latch_wait_time xs:long total_extended_latch_wait_time - Total extended latch wait time monitor element
total_extended_latch_waits xs:long total_extended_latch_waits - Total extended latch waits monitor element
total_hash_grpbys xs:long total_hash_grpbys - Total hash group by operations
total_hash_joins xs:long total_hash_joins - Total Hash Joins monitor element
total_hash_loops xs:long total_hash_loops - Total Hash Loops monitor element
total_implicit_compilations xs:long total_implicit_compilations - Total implicit complications monitor element
total_implicit_compile_proc_time xs:long total_implicit_compile_proc_time - Total implicit compile processing time monitor element
total_implicit_compile_time xs:long total_implicit_compile_time - Total implicit compile time monitor element
total_index_build_proc_time xs:long total_index_build_proc_time - Total non-wait time spent building indexes due to index creation
total_index_build_time xs:long total_index_build_time - Total time spent building indexes due to index creation
total_indexes_built xs:long total_indexes_built - Total number of indexes built
total_load_proc_time xs:long total_load_proc_time - Total load processing time monitor element
total_load_time xs:long total_load_time - Total load time monitor element
total_loads xs:long total_loads - Total loads monitor element
total_olap_funcs xs:long total_olap_funcs - Total OLAP Functions monitor element
total_peas xs:long total_peas - Total partial early aggregations monitor element
total_peds xs:long total_peds - Total partial early distincts monitor element
total_reorg_proc_time xs:long total_reorg_proc_time - Total reorganization processing time monitor element
total_reorg_time xs:long total_reorg_time - Total reorganization time monitor element
total_reorgs xs:long total_reorgs - Total reorganizations monitor element
total_rollback_proc_time xs:long total_rollback_proc_time - Total rollback processing time monitor element
total_rollback_time xs:long total_rollback_time - Total rollback time monitor element
total_routine_invocations xs:long total_routine_invocations - Total routine invocations monitor elements
total_routine_time xs:long total_routine_time - Total routine time monitor element
total_routine_user_code_proc_time xs:long total_routine_user_code_proc_time - Total routine user code processing time monitor element
total_routine_user_code_time xs:long total_routine_user_code_time - Total routine user code time monitor element
total_rqst_mapped_in xs:long total_rqst_mapped_in - Total request mapped-in monitor element
total_rqst_mapped_out xs:long total_rqst_mapped_out - Total request mapped-out monitor element
total_rqst_time xs:long total_rqst_time - Total request time monitor element
total_runstats_proc_time xs:long total_runstats_proc_time - Total runtime statistics processing time monitor element
total_runstats_time xs:long total_runstats_time - Total runtime statistics time monitor element
total_runstats xs:long total_runstats - Total runtime statistics monitor element
total_sec_cons xs:long total_sec_cons - Secondary Connections monitor element
total_section_proc_time xs:long total_section_proc_time - Total section processing time monitor element
total_section_sort_proc_time xs:long total_section_sort_proc_time - Total section sort processing time monitor element
total_section_sort_time xs:long total_section_sort_time - Total section sort time monitor element
total_section_sorts xs:long total_section_sorts - Total section sorts monitor element
total_section_time xs:long total_section_time - Total section time monitor element
total_sorts xs:long total_sorts - Total sorts monitor element
total_stats_fabrication_proc_time xs:long total_stats_fabrication_proc_time - Total statistics fabrication processing time monitor element
total_stats_fabrication_time xs:long total_stats_fabrication_time - Total statistics fabrication time monitor element
total_stats_fabrications xs:long total_stats_fabrications - Total statistics fabrications monitor elements
total_sync_runstats_proc_time xs:long total_sync_runstats_proc_time - Total synchronous RUNSTATS processing time monitor element
total_sync_runstats_time xs:long total_sync_runstats_time - Total synchronous RUNSTATS time monitor elements
total_sync_runstats xs:long total_sync_runstats - Total synchronous RUNSTATS activities monitor element
total_wait_time xs:long total_wait_time - Total wait time monitor element
tq_sort_heap_rejections xs:long tq_sort_heap_rejections - Table queue sort heap rejections monitor element
tq_sort_heap_requests xs:long tq_sort_heap_requests - Table queue sort heap requests monitor element
tq_tot_send_spills xs:long tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
uid_sql_stmts xs:long uid_sql_stmts - Update/Insert/Delete SQL Statements Executed monitor element
unread_prefetch_pages xs:long unread_prefetch_pages - Unread prefetch pages monitor element
vectored_ios xs:long vectored_ios - Number of vectored I/O requests monitor element
wlm_queue_assignments_total xs:long wlm_queue_assignments_total - Workload manager total queue assignments monitor element
wlm_queue_time_total xs:long wlm_queue_time_total - Workload manager total queue time monitor element
xquery_stmts xs:long xquery_stmts - XQuery Statements Attempted monitor element

Usage notes

The schema for the XML document that is returned in the DETAILS column is available in the file sqllib/misc/DB2MonRoutines.xsd. Further details can be found in the file sqllib/misc/DB2MonCommon.xsd.

Example

Retrieve information about rows_read, num_locks_waiting, total_cpu_time, and direct_reads, at the database level on the current member.
SELECT wlmetrics.member as member,
       detmetrics.rows_read as rows_read,
       detmetrics.num_locks_waiting as num_locks_waiting,
       detmetrics.total_cpu_time as total_cpu_time,
       detmetrics.direct_reads as direct_reads
FROM TABLE(MON_GET_DATABASE_DETAILS(NULL)) AS WLMETRICS,
XMLTABLE (XMLNAMESPACES( DEFAULT 'http://www.ibm.com/xmlns/prod/db2/mon'),
        '$detmetric/db2_database' 
        PASSING XMLPARSE(DOCUMENT WLMETRICS.DETAILS) as "detmetric"
COLUMNS "ROWS_READ" INTEGER PATH 'system_metrics/rows_read',
        "NUM_LOCKS_WAITING" INTEGER PATH 'system_metrics/lock_waits',
        "TOTAL_CPU_TIME" INTEGER PATH 'system_metrics/total_cpu_time',
        "DIRECT_READS" INTEGER PATH 'system_metrics/direc_reads'
) AS DETMETRICS;
This query returns the following output: 
MEMBER ROWS_READ   NUM_LOCKS_WAITING TOTAL_CPU_TIME DIRECT_READS
------ ----------- ----------------- -------------- ------------
     0        3288                 0        2330014            -