DB2 10 for z/OS Database Administrator — Question 15

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?

Answer options

• A. UPDATE DB CFG USING MON_OBJ_METRICS BASE
• B. UPDATE DB CFG USING MON_ACT_METRICS BASE
• C. UPDATE DBM CFG USING DFT_MON_BUFPOOL ON
• D. UPDATE MONITOR SWITCHES USING BUFFERPOOL ON

Correct answer: C

Explanation

The correct answer is C, as enabling DFT_MON_BUFPOOL allows the database to monitor buffer pool activity, which is necessary for accurate metrics. The other options do not specifically address enabling the monitoring of buffer pool performance, which is essential for the metrics in question.