When querying the MON_GET_TABLESPACE table function, the values for many of the performance metrics like POOL_DATA_P_READS and
POOL_DATA_L_READS are showing 0, even though there is activity occurring in the database. Which command must be executed to enable the table function to return actual data?
To enable the MON_GET_TABLESPACE table function to return actual data for performance metrics like POOL_DATA_P_READS and POOL_DATA_L_READS, you need to update the database configuration using the MON_OBJ_METRICS parameter. This parameter collects metrics that are relevant to objects such as buffer pools, containers, and tablespaces, which are all queried by the MON_GET_TABLESPACE table function. Therefore, executing the command 'UPDATE DB CFG USING MON_OBJ_METRICS BASE' ensures that these metrics are collected and returned accurately.
Correct answer is A https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0053943.html
The answer A is correct because MON_OBJ_METRICS collect all metrics that are reported through the following table functions : - MON_GET_BUFFERPOOL - MON_GET_CONTAINER - MON_GET_TABLESPACE
The command "Update Monitor Switches" and the parameter DFT_MON_BUFPOOL are the older methodology which is referred as "snapshot monitoring", you used to have no choice but the "GET SNAPSHOT" command". The tables MON_GET_XXX are not updated by these older methodology. MON_ACT_METRICS and MON_OBJ_METRICS are the new methodology to monitor your system and update the tables "MON_GET_XXX". See reference : https://datageek.blog/2013/07/16/two-worlds-of-db2-luw-performance-monitoring/
MON_ACT_METRICS see reference : https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.config.doc/doc/r0054936.html
The answer B is not correct because MON_ACT_METRICS is for the following monitor interfaces report activity metrics: - MON_GET_PKG_CACHE_STMT_DETAILS - MON_GET_ACTIVITY - MON_GET_ACTIVITY_DETAILS - MON_GET_PKG_CACHE_STMT - WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES - Package cache event monitor - Activity event monitor