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. To adjust the checkpoint interval, use the SET OPTION statement. For syntax, see the SET OPTION statement in Reference: Statements and Options. Adjusting the checkpoint time or issuing explicit checkpoints may be unnecessary. 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.”
