CHECKPOINT

The CHECKPOINT statement forces the database server to execute a checkpoint. Checkpoints are also performed automatically by the database server according to an internal algorithm. It is not normally required for applications to issue the CHECKPOINT statement.

DBA authority is required to checkpoint the network database server.

No permissions are required to checkpoint the personal database server.

None.

• Backup and data recovery
• Checkpoint logs
• checkpoint_time option
• recovery_time option