GCIH · Question #204
You want to measure the number of heaps used and overflows occurred at a point in time. Which of the following commands will you run to activate the appropriate monitor?
The correct answer is D. UPDATE DBM CONFIGURATION USING DFT_MON_SORT. The DB2 DBM configuration parameter DFT_MON_SORT activates the sort monitor switch, which is specifically responsible for tracking sort heap usage and the number of sort overflow events.
Question
You want to measure the number of heaps used and overflows occurred at a point in time. Which of the following commands will you run to activate the appropriate monitor?
Options
- AUPDATE DBM CONFIGURATION USING DFT_MON_TABLE
- BUPDATE DBM CONFIGURATION DFT_MON_TIMESTAMP
- CUPDATE DBM CONFIGURATION USING DFT_MON_BUFPOOL
- DUPDATE DBM CONFIGURATION USING DFT_MON_SORT
How the community answered
(36 responses)- A8% (3)
- B14% (5)
- C6% (2)
- D72% (26)
Why each option
The DB2 DBM configuration parameter DFT_MON_SORT activates the sort monitor switch, which is specifically responsible for tracking sort heap usage and the number of sort overflow events.
DFT_MON_TABLE activates the table activity monitor, which tracks row-level read and write statistics rather than heap usage or overflow counts.
The syntax shown for DFT_MON_TIMESTAMP is missing the required USING keyword, and timestamp monitoring does not relate to heap or overflow measurement.
DFT_MON_BUFPOOL activates the buffer pool monitor, which tracks buffer pool hit ratios and I/O activity rather than sort heap usage or overflow events.
Setting DFT_MON_SORT to ON via 'UPDATE DBM CONFIGURATION USING DFT_MON_SORT ON' enables the DB2 sort event monitor switch, causing the database manager to collect metrics on sort heap allocations and sort overflow counts. This is the correct monitor for measuring heap usage and overflow occurrences because sort overflows directly reflect cases where the allocated sort heap was insufficient and disk spill occurred.
Concept tested: DB2 sort monitor activation for heap and overflow tracking
Source: https://www.ibm.com/docs/en/db2/11.5?topic=parameters-dft-mon-sort-default-sort-switch
Topics
Community Discussion
No community discussion yet for this question.