Online and Offline Checkpoints
Checkpoints can be performed online or offline.
An online checkpoint, which is the default, can be performed while users are connected to the database. An online checkpoint stalls until any transactions running against the database are committed. Any new transactions started during the stall phase of the online checkpoint cannot run until the stall phase is completed.
An offline checkpoint can be performed when no one is using the database.
Perform an Offline Checkpoint
A checkpoint taken offline is performed when no one is using the database.
To perform an offline checkpoint
Issue the following command at the operating system prompt:
ckpdb -l dbname
The -l flag causes the checkpoint to be taken offline.
When using the -l flag, you can also use the "wait" flag (+w or -w):
+w
Waits for as long as necessary for the database to be free before taking the checkpoint.
-w
(Default) Returns an error message if the database is busy.
Last modified date: 01/30/2023