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.