Technology preview of managing restore operations by using the Db2uRestore resource

Prerequisites

• A working Db2uCluster custom resource deployment.
• A successfully completed Db2uBackup resource.

Before you restore

Do not restore any backups that were made after another backup was taken and subsequently restored. Doing so can result in issues when rolling forward and require manual intervention, such as dropping the database prior to the next restore.

Creating a Db2uRestore resource to restore a backup of your Db2 instance

You create a Db2uRestore custom resource through a YAML script. You can do this in several ways:

• Through the Red Hat® OpenShift® console.
• Through the Red Hat OpenShift command-line tool.
• Through the command-line tool of a Kubernetes cluster.

To use the Red Hat OpenShift console, go to Installed Operators > IBM Db2 and click the Db2uRestore tab. Through this tab page you create your Db2uRestore resource, either by following the on-screen instructions of the form view, or by entering and running the YAML script.
Your YAML script contains the following API call:

apiVersion: db2ubnr.databases.ibm.com/v1alpha1
kind: Db2uRestore
metadata:
  name: <name of your db2ubackup>
spec:
  db2uCluster: <name of your existing db2uCluster>
  db2uBackup: <name of your existing db2uBackup>

where

• metadata.name is a valid Kubernetes resource name.
  NOTE: A restore name cannot be reused, even if the Db2uRestore resource is deleted.
• spec.db2uCluster is an active db2uCluster in the same namespace as the Db2uRestore.
• spec.db2uBackup is a complete db2uBackup in the same namespace as the Db2uRestore.

The following example shows the command syntax for running the Db2uRestore utility to recover the db2uBackup resource mybackup:

apiVersion: db2ubnr.databases.ibm.com/v1alpha1
kind: Db2uRestore
metadata:
  name: myrestore
spec:
  db2uCluster: mycluster
  db2uBackup: mybackup

You can check the status of the backup operation by running the following command:

oc get db2urestore <mybackup>

The Db2uRestore status indicates the state of the restore operation:

• InProgress - The restore operation is ongoing.
• Complete - The restore operation was successful.
• InvalidSpec -There is something wrong with the fields of the Db2uRackup CR.
• Error - The restore operation failed.