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.
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

Copyright© 2020 HCL Technologies Limited