AUTO_CKPTS configuration parameter
The AUTO_CKPTS configuration parameter allows the server to trigger checkpoints more frequently to avoid the blocking of transactions.
- onconfig.std value
- Not set. If the AUTO_TUNE configuration parameter is set to 1, automatic checkpoints are 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_CKPTS value is not set in your current onconfig file and you edit the AUTO_TUNE configuration parameter and restart the database server