PrepAway - Latest Free Exam Questions & Answers

How would you enable self-tuning of memory areas that a…

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

PrepAway - Latest Free Exam Questions & Answers

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 at least one entry is present in
SYSCAT.BUFFERPOOLDBPARTITIONS.

Explanation:
https://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.perf.doc/
doc/t0021629.html (enabling self-tuning memory, procedure)


Leave a Reply