DB2 Version 10.1 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 an earlier version of DB2®, the mon_obj_metrics configuration parameter retains the value that it had before you upgraded your database.

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.