Examice

Exam C2090-600 All QuestionsBrowse all questions from this exam

Question 34

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

Set the DB2_WORKLOAD aggregate registry variable to ANALYTICS for self-tuning of the sort parameter on workloads that access column-organized tables.

Set the SELF_TUNING_MEM database configuration parameter to ON using the UPDATE DATABASE CONFIGURATION command or the db2CfgSet API.

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.

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

To enable self-tuning of memory areas that are controlled by memory configuration parameters, you need to set the SELF_TUNING_MEM database configuration parameter to ON using the UPDATE DATABASE CONFIGURATION command or the db2CfgSet API. This allows the DB2 memory tuner to automatically adjust memory allocations based on the current workload, ensuring optimal performance.

Discussion

db2testerOption: B

The answer B is correct, because, the following database memory-related configuration parameters are tuned automatically when the STMM future is enabled via the self_tuning_mem database configuration parameter: - database_memory (bufferpools, dbheap, util_heap_sz, pckcachesz, catalogcache_sz, sheapthres_shr). - maxlocks - pckcachsz - sheapthres_shr - sortheap