IBM
C2090-600 · Question #61
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…
The correct answer is C. UPDATE DBM CFG USING DFT_MON_BUFPOOL ON. See the full explanation below for the reasoning.
Question
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?
Options
- AUPDATE DB CFG USING MON_OBJ_METRICS BASE
- BUPDATE DB CFG USING MON_ACT_METRICS BASE
- CUPDATE DBM CFG USING DFT_MON_BUFPOOL ON
- DUPDATE MONITOR SWITCHES USING BUFFERPOOL ON
How the community answered
(26 responses)- A4% (1)
- B4% (1)
- C85% (22)
- D8% (2)
Community Discussion
No community discussion yet for this question.