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 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.