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
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
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
db2tester
5 years ago