Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

checkpoint_time option

Sets the maximum number of minutes that the database server runs without doing a checkpoint.

Allowed values




  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY SYSTEM OPTION No No
Allowed to set temporarily? Yes, with SET ANY SYSTEM OPTION No No

This option is used with the recovery_time option to decide when checkpoints should be done.

You may need to shut down and restart the database server for the change to take effect.