Self-tuning memory can be disabled for the entire database
or for one or more configuration parameters or buffer pools.
About this task
If self-tuning memory is disabled for the entire database,
the memory configuration parameters and buffer pools that are set
to AUTOMATIC remain enabled for automatic tuning; however, the memory
areas remain at their current size.
Procedure
- Disable self-tuning memory for the database by setting
the self_tuning_mem database configuration parameter
to OFF using the UPDATE DATABASE CONFIGURATION command
or the db2CfgSet API.
- To disable the self tuning of memory areas that are controlled
by memory configuration parameters, set the relevant configuration
parameters to MANUAL or specify numeric parameter values using the UPDATE
DATABASE CONFIGURATION command or the db2CfgSet API.
- To disable the self tuning of a buffer pool, set the buffer
pool size to a specific value using the ALTER BUFFERPOOL statement.
Results
Note: - In some cases, a memory configuration parameter can be enabled
for self tuning only if another related memory configuration parameter
is also enabled. This means that, for example, disabling self-tuning
memory for the locklist or the sortheap database
configuration parameter disables self-tuning memory for the maxlocks or
the sheapthres_shr database configuration parameter,
respectively.