15. Performing Backup and Recovery : Backup by Checkpoints : Checkpoint Selected Tables
 
Share this page                  
Checkpoint Selected Tables
Use table-level checkpoints only as a supplement to database-level checkpoints.
To checkpoint selected tables
Issue the following command at the operating system prompt:
ckpdb dbname [-table=tablename {, tablename}]
The ckpdb command takes a checkpoint of the specified tables in the database.
Table level checkpoint is not allowed as the first checkpoint.
To take a table-level checkpoint, a full database checkpoint with journaling turned on is required:
ckpdb +j dbname
If this requirement is not met, a command such as the following:
ckpdb dbname –table=test2
fails with
E_DM116E_CPP_TBL_CKP_DISALLOWED Error performing table level checkpoint. In order to perform a table level checkpoint, table level recovery must be allowed on table and table must be journaled.