Checkpoint (Back up) a Database with ckpdb
A checkpoint is a snapshot of the database. Checkpoints can be taken when the database is either offline (no one is using the database) or online.
To checkpoint a database online
Issue the following command at the operating system prompt of the master node:
ckpdb dbname
A new online checkpoint for the specified database is created.
To checkpoint a database offline
Issue the following command at the operating system prompt of the master node:
ckpdb -l dbname
A new offline checkpoint for the specified database is created. The -l flag causes the checkpoint to be taken offline. When using the -l flag, you can also use the "wait" flag, which waits (+w) as long as necessary for the database to be free before taking the checkpoint or returns an error message if the database is busy (-w, the default).