AUTO_LRU_TUNING configuration parameter

Use the AUTO_LRU_TUNING configuration parameter to enable automatic LRU tuning, which automatically maintains enough clean pages for page replacement.

onconfig.std value
Not set. If the AUTO_TUNE configuration parameter is set to 1, automatic LRU tuning is enabled.
values
0 = Off

1 = On

takes effect
After you edit your onconfig file and restart the database server.
When you reset the value dynamically in your onconfig file by running the onmode -wf command.
When you reset the value in memory by running the onmode -wm command.
If an AUTO_LRU_TUNING value is not set in your current onconfig file and you edit the AUTO_TUNE configuration parameter and restart the database server

Usage

Automatic LRU tuning changes affect all buffer pools and adjust the lru_min_dirty and lru_max_dirty values in the BUFFERPOOL configuration parameter.


Copyright© 2019 HCL Technologies Limited