DB2 10 for z/OS Database Administrator — Question 26

How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?

Answer options

• A. Set the DB2_WORKLOAD aggregate registry variable to ANALYTICS for self-tuning of the sort parameter on workloads that access column-organized tables.
• B. Set the SELF_TUNING_MEM database configuration parameter to ON using the UPDATE DATABASE CONFIGURATION command or the db2CfgSet API.
• C. Set the sortheap or the sheapthres_shr configuration parameters to AUTOMATIC using the UPDATE DATABASE CONFIGURATION command or the db2CfgSet API with sheapthres set to at least 4K.
• D. Use AUTOMATIC keyword for the buffer pool size on the CREATE BUFFERPOOL statement or the ALTER BUFFERPOOL statement after making sure that

Correct answer: B

Explanation

The correct answer is B, as setting the SELF_TUNING_MEM parameter to ON directly enables self-tuning for memory management. Option A pertains to workload-specific tuning, while option C focuses on setting heap parameters, neither of which activate self-tuning. Option D discusses buffer pool configuration but does not address the self-tuning feature directly.