How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?
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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |