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?
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 command to activate the appropriate monitor for measuring the number of heaps used and overflows occurred at a point in time is UPDATE DBM CONFIGURATION USING DFT_MON_BUFPOOL. This command is used to enable monitoring of buffer pool activities, which includes monitoring heap usage and overflows. The other options do not specifically pertain to monitoring heaps and overflows.
A This command updates the database manager configuration to enable monitoring for table-related metrics, including heap usage and overflows. The command UPDATE DBM CONFIGURATION USING DFT_MON_SORT is used to activate monitoring for sorting activities in a DB2 database, such as the number of sorts performed and the amount of time spent on sorting operations. It does not specifically monitor the number of heaps used and overflows occurred at a point in time.