nerdexam
GIAC

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.

Vulnerability Exploitation & Privilege Escalation

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)
  • A
    8% (3)
  • B
    14% (5)
  • C
    6% (2)
  • D
    72% (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.

AUPDATE DBM CONFIGURATION USING DFT_MON_TABLE

DFT_MON_TABLE activates the table activity monitor, which tracks row-level read and write statistics rather than heap usage or overflow counts.

BUPDATE DBM CONFIGURATION DFT_MON_TIMESTAMP

The syntax shown for DFT_MON_TIMESTAMP is missing the required USING keyword, and timestamp monitoring does not relate to heap or overflow measurement.

CUPDATE DBM CONFIGURATION USING DFT_MON_BUFPOOL

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.

DUPDATE DBM CONFIGURATION USING DFT_MON_SORTCorrect

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

#heap overflow#DB2 monitor#buffer monitoring#database configuration

Community Discussion

No community discussion yet for this question.

Full GCIH Practice