Backing up and restoring the replication environment in Db2 Warehouse

You can back up and restore the NFS volumes that contain your replication environment.

About this task

You perform the backup and restore by using the Cloud Pak for Data volume backup and restore utility, cpd-cli backup-restore.

Replication does not support backup and restore operations that use the OADP utility.

Important: Perform the backup and restore operation on all volumes that are used in the replication environment, including Db2 Warehouse and any replication sources and targets. Also note that the cpd-cli backup-restore utility only backs up and restores instances that are in the same cluster. Instances in other clusters might be newer, so additional considerations would be needed to restore, including handling of any DDL changes.

Procedure

  1. Install the cpd-cli backup-restore utility.
  2. At the source, quiesce applications that are involved in replication and record the quiesce timestamp.
  3. Wait for replication to catch up, that is, for the last consistency point to be greater than the quiesce timestamp.
  4. Stop replication after all changes are applied.
  5. Follow these instructions to perform the backup and restore:

    Note that the replication control tables are restored to the point-in-time of the backup image. Any tables that are added or removed or altered after the backup are lost. Any table that is activated after the backup must be reactivated.

  6. Start the capture process with warmns with LSN=FFFF, or use the migrate=y option to start capture at the end of the logs.
  7. Restart quiesced applications.