Use this statement to checkpoint the database.

Syntax

CHECKPOINT

Remarks

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.

Permissions

DBA authority is required to checkpoint the network database server.

No permissions are required to checkpoint the personal database server.

Side effects

None.

See also

• Backup and data recovery
• Understanding the checkpoint log
• checkpoint_time option [database]
• recovery_time option [database]

Standards and compatibility