DB2 10.5 for Linux, UNIX, and Windows

mon_obj_metrics - Monitoring object metrics configuration parameter

This parameter controls the collection of data object metrics on an entire database.

Configuration type

Database

Parameter type

Configurable online

Default [range]

EXTENDED [NONE, BASE, EXTENDED]

Upgrade Note

If you are upgrading from Version 9.8 or earlier, the mon_obj_metrics configuration parameter retains the value that it had before you upgraded your database.
If you are upgrading from a DB2 Version 9.8 Fix Pack 4 pureScale environment or earlier, the value of mon_req_metrics is set to the value on member 0.

Set this configuration parameter to BASE to collect all metrics that are reported through the following table functions:

MON_GET_BUFFERPOOL
MON_GET_CONTAINER
MON_GET_TABLESPACE

Set this configuration parameter to EXTENDED to collect additional metrics that are reported through the following table functions:

Table 1. Metrics returned with EXTENDED option
Table Function	Metrics Reported
MON_GET_INDEX	object_index_gbp_indep_pages_found_in_lbp object_index_gbp_invalid_pages object_index_gbp_l_reads object_index_gbp_p_reads object_index_l_reads object_index_lbp_pages_found object_index_p_reads
MON_GET_INDEX_USAGE_LIST	object_index_gbp_indep_pages_found_in_lbp object_index_gbp_invalid_pages object_index_gbp_l_reads object_index_gbp_p_reads object_index_l_reads object_index_lbp_pages_found object_index_p_reads
MON_GET_TABLE	direct_read_reqs direct_reads direct_write_reqs direct_writes lock_escals lock_escals_global lock_wait_time lock_wait_time_global lock_waits lock_waits_global object_data_gbp_indep_pages_found_in_lbp object_data_gbp_invalid_pages object_data_gbp_l_reads object_data_gbp_p_reads object_data_l_reads object_data_lbp_pages_found object_data_p_reads object_xda_gbp_indep_pages_found_in_lbp object_xda_gbp_invalid_pages object_xda_gbp_l_reads object_xda_gbp_p_reads object_xda_l_reads object_xda_lbp_pages_found object_xda_p_reads
MON_GET_TABLE_USAGE_LIST	direct_read_reqs direct_reads direct_write_reqs direct_writes lock_escals lock_escals_global lock_wait_time lock_wait_time_global lock_waits lock_waits_global object_data_gbp_indep_pages_found_in_lbp object_data_gbp_invalid_pages object_data_gbp_l_reads object_data_gbp_p_reads object_data_l_reads object_data_lbp_pages_found object_data_p_reads object_xda_gbp_indep_pages_found_in_lbp object_xda_gbp_invalid_pages object_xda_gbp_l_reads object_xda_gbp_p_reads object_xda_l_reads object_xda_lbp_pages_found object_xda_p_reads overflow_accesses overflow_creates rows_deleted rows_inserted rows_read rows_updated

If you set this configuration parameter to NONE, the metrics reported through the previously mentioned table functions are not collected.