Checkpoint service using the vxsfadm utility for the DB2 application.

vxsfadm -s checkpoint -a db2 -o <operation>
[ -c config-file ]
[ -r Respository-host ]
[--<checkpoint_name> <value>]
[--<db2instance> <Value>]
[--<db2database> <Value>]

The checkpoint service is used to create a point in time copy the db2 database mounts using VxFS checkpoints. The point in time copies can be used to create clone or be mounted for backups.

Below is an explanation of the configuration parameters specific for the db2 application supported by the checkpoint service, which can be specified in the configuration file or the environment. Also specified are the command line option for the same.
DB2INSTANCE	The value is the DB2 Instance name to be used. commandline --db2instance/--I This is a mandatory parameter.
DB2DATABASE	The value is the DB2 database name. commandline --db2dataabse/--D This is a mandatory option.
APP_MODE	This parameter specifies if the db2 database would be online/offline when the checkpoint is created for the applicaiton. online: The DB2 database is put in write suspend mode before the checkpoint is created on the database mounts. The database is released from write suspend after the checkpoint is created. offline: The DB2 database is offline/not active at the time the checkpoint is created. commandline --app_mode=online/offline commandline --online/--offline This is a not a mandatory option. The default mode is online .
CLONE_NAME	This parameter specifies the name with which the cloned database would be got up. commandline --clone_name This is not a mandatory option.
Service Specific parameters	The paramameters below are specific for the checkpoint service, please refer the vxsfadm-checkpoint(1M) man page for more information: CHECKPOINT_NAME CLONE_PATH SNAPSHOT_REMOVABLE

vxsfadm -s checkpoint -a db2 -o getappdata --db2instance=<instance name> --db2database=<database name>

The above operation would gather all the information necessary for checkpoint creation when the database is offline.

The above command must be run when the database is up. If an offline checkpoint is attempted to be created without performing the data gathering operation then offline checkpoint creation would fail.

Checkpoint create:	online mode checkpoints vxsfadm -s checkpoint -a db2 -o create --db2instance=<instance name> --db2database=<database name> --checkpoint_name=xxx The above operation would create a removable online checkpoint over all the mounts of the database <database name>
Checkpoint Destroy	Destroy a cloned database vxsfadm -s checkpoint -a db2 -o destroy --db2instance=<instance name> --db2database=<database name> --checkpoint_name=xxx --clone_name=clone1 The above command would shutdown the clone database clone1 and proceed with unmount and destroy of the checkpoint xxx_rw_yyyy Destroy a checkpoint vxsfadm -s checkpoint -a db2 -o destroy --db2instance=<instance name> --db2database=<database name> --checkpoint_name=xxx The above command would destroy the checkpoint xxx, if mounted the same would be unmounted before the checkpoint is destroyed.
Checkpoint Unmount	Unmount a clone database vxsfadm -s checkpoint -a db2 -o umount --db2instance=<instance name> --db2database=<database name> --checkpoint_name=xxx --clone_name=clone1 The above command would shutdown the clone database clone1 and proceed with unmount of the checkpoint xxx_rw_yyyy Unmount a checkpoint vxsfadm -s checkpoint -a db2 -o umount --db2instance=<instance name> --db2database=<database name> --checkpoint_name=xxx The above command would unmount of the checkpoint xxx, if mounted the same would be unmounted.
Mount a checkpoint in read_only mode	vxsfadm -s checkpoint -a db2 -o mount --db2instance=<instance name> --db2database=<database name> --checkpoint_name=xxx --clone_path=/tmp/mnt1 The above operation would simply mount the checkpoint xxx in read_only mode at /tmp/mnt1
Mount a checkpoint in read_write mode	vxsfadm -s checkpoint -a db2 -o mountrw --db2instance=<instance name> --db2database=<database name> --checkpoint_name=xxx --clone_path=/tmp/clone1 The above operation would simply create a checkpoint of the checkpoint xxx and mount the same in read_write mode at /tmp/clone1
Clone the database using a checkpoint	vxsfadm -s checkpoint -a db2 -o clon --db2instance=<instance name> --db2database=<database name> --checkpoint_name=xxx --clone_name=clone1 --clone_path=/tmp/clone1 The above operation would clone the database SID to the name clone1 and have the database clone mounted at /tmp/clone1

The database should have the following configurations:

1	The database should have all of its DB_PATHs mounted on a vxfs filesystem
2	If a logretain method is used then atleast one of the methods should be a vxfs filesystem
3	The DB2 database should be on a single partition. Multiple partitioned databases are not supported.

vxsfadm(1M), vxsfadm-db2(1M), vxsfadm-checkpoint(1M)

vxsfadm-flashsnap(1M), vxsfadm-sos(1M), vxsfadm-filesnap(1M) vxsfadm-db2-flashsnap(1M)