Creating Storage Checkpoints using db2ed_ckptcreate
You can use the command to create a Storage Checkpoint from the command line.
Storage Checkpoints can be either online or offline. If online is specified, the database is put into write suspend mode when the Storage Checkpoint is created. If offline is specified, the database is expected to be down.
Before creating a Storage Checkpoint, the following conditions must be met:
To create Storage Checkpoints while the database is online
-
Use the db2ed_ckptcreate command as follows:
$ /opt/VRTS/bin/db2ed_ckptcreate -D PROD -o online
An online Storage Checkpoint Checkpoint_971672042
is created at GMT 2004-05-01-18.22.34.0000.
To create Storage Checkpoints without updating the repository while the database is online
-
Use the db2ed_ckptcreate command as follows:
$ /opt/VRTS/bin/db2ed_ckptcreate -D PROD -o online -n
An online Storage Checkpoint Checkpoint_971672043
is created at GMT 2004-05-01-18.22.34.0000.
To create Storage Checkpoints while the database is offline
-
Terminate the database before creating the offline Storage Checkpoint:
# db2 terminate
-
Use the db2ed_ckptcreate command as follows:
$ /opt/VRTS/bin/db2ed_ckptcreate -D PROD -o offline
An offline Storage Checkpoint Checkpoint_971672044
is created at GMT 2004-05-01-18.22.34.0000.
The default option is online.
To assign a Storage Checkpoint allocation policy to a Storage checkpoint
-
Use the db2ed_ckptcreate command as follows:
$ /opt/VRTS/bin/db2ed_ckptcreate -D PROD -o online -p \
ckpt_data,ckpt_metadata
Creating online Storage Checkpoint of database PROD.
Storage Checkpoint Checkpoint_971672044 created.
To create Storage Checkpoints on multiple partitions
-
As the DB2 instance owner, use the db2ed_ckptcreate_all command as follows:
$ /opt/VRTS/bin/db2ed_ckptcreate_all -I db2inst -D PROD
where db2inst is the instance name.
An online Storage Checkpoint Checkpoint_1219203910 is created
at GMT 2008-08-20:03:45:15