IBM
C2090-600 · Question #68
How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?
The correct answer is B. Set the SELF_TUNING_MEM database configuration parameter to ON using the UPDATE. See the full explanation below for the reasoning.
Question
How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?
Options
- ASet the DB2_WORKLOAD aggregate registry variable to ANALYTICS for self-tuning of the sort
- BSet the SELF_TUNING_MEM database configuration parameter to ON using the UPDATE
- CSet the sortheap or the sheapthres_shr configuration parameters to AUTOMATIC using the
- DUse AUTOMATIC keyword for the buffer pool size on the CREATE BUFFERPOOL statement or
How the community answered
(54 responses)- A2% (1)
- B80% (43)
- C6% (3)
- D13% (7)
Community Discussion
No community discussion yet for this question.