Taking an offline snapshot of your IBM® Db2 Warehouse database

An offline snapshot is also known as a cold snapshot.

About this task

To perform this task, you require root authority.

Procedure

  1. On the head node, stop the Db2® Warehouse services by issuing the following Docker or Podman command:
    docker exec –it Db2wh stop
    podman exec –it Db2wh stop
  2. On each node, stop the Db2 Warehouse container by issuing the following Docker or Podman command:
    docker stop Db2wh
    podman stop Db2wh
  3. Use the snapshot technology of your choice to take your snapshot backup.
    Alternatively, issue a cpio or tar command to take a file system-level copy. Make sure that the copy is complete before you proceed to the next step. For example:
    • To create a snapshot backup in the mnt/clusterfs2/snap1 directory:
      find /mnt/clusterfs -print | cpio -o --file /mnt/clusterfs2/snap1
    • To create a snapshot backup file with the name /mnt/clusterfs2/snap1.tgz:
      cd /mnt/clusterfs2; tar -zcvf -C /mnt/clusterfs snap1.tgz
  4. On each node, start the container and services by issuing the following Docker or Podman command:
    docker start Db2wh
    podman start Db2wh