Self-tuning memory - IBM DB2 9.7 for Linux, UNIX, and Windows

Self-tuning memory
Starting in DB2® Version 9, a memory-tuning feature simplifies the task of memory configuration by automatically setting values for several memory configuration parameters. When enabled, the memory tuner dynamically distributes available memory resources among the following memory consumers: buffer pools, locking memory, package cache, and sort memory.

Enabling self-tuning memory
Self-tuning memory simplifies the task of memory configuration by automatically setting values for memory configuration parameters and sizing buffer pools.

Disabling self-tuning memory
Self-tuning memory can be disabled for the entire database or for one or more configuration parameters or buffer pools.

Determining which memory consumers are enabled for self tuning
You can view the self-tuning memory settings that are controlled by configuration parameters or that apply to buffer pools.

Self-tuning memory in partitioned database environments
When using the self-tuning memory feature in partitioned database environments, there are a few factors that determine whether the feature will tune the system appropriately.

Using self-tuning memory in partitioned database environments
When self-tuning memory is enabled in partitioned database environments, there is a single database partition (known as the tuning partition) that monitors the memory configuration and propagates any configuration changes to all other database partitions to maintain a consistent configuration across all the participating database partitions.

Self-tuning memory overview