Most Sybase IQ checkpoints occur automatically. You can also set explicit checkpoints, although you do not need to do so.
A checkpoint occurs at the following times:
When a transaction issues a CHECKPOINT command.
When the CHECKPOINT_TIME is exceeded.
At the start and end of the backup process.
When the database server is shut down.
The CHECKPOINT_TIME is the maximum time that can pass between checkpoints. It is set by default at 60 minutes. You can adjust the checkpoint interval with the SET OPTION command; see the Sybase IQ Reference Manual for details. You probably do not need to adjust the checkpoint time or issue explicit checkpoints, however. Controlling checkpoints is less important in Sybase IQ than in OLTP database products, because IQ writes the actual data pages after each transaction commits.
For more information on checkpoints in recovery, see “How transaction information aids recovery.”
