Restoring a Db2 instance

With R‑Cloud, you can restore an entire Db2 instance—all Db2 databases and the Db2 instance configuration.

Prerequisite

You must be granted the following permissions: to run the db2inidb command on the databases, to terminate the database connections, to deactivate the databases, to perform the rollforward recovery, and to start and stop the Db2 instance.

To access the Applications panel, in the navigation pane, click Applications Applications.

Procedure

  1. In the Applications panel, click the Db2 application whose Db2 instance you want to restore to open the Detail view.

    Note  The Detail view appears only if you click an application. Selecting the check box before the name of the application does not open the Detail view.

  2. In the Detail view that appears at the bottom of the screen, select the preferred restore point.

  3. Click Restore Files Restore.

  4. Select Restore Db2 Instance, and then click Next.

  5. From the Restore From drop-down menu, select which tier you want to use for the restore. Your restore point can contain one or more tiers among which you can select:

    • Automatic: This option ensures the fastest and most cost-effective restore.

    • Backup (Snapshot)

    • Backup (Target)

    • Copy

    • Archive—(daily, weekly, monthly, yearly)

    Note  The databases that belong to the Db2 instance are listed under Databases. You can search for a database by entering its name in the Search field and then pressing Enter.

  6. Click Next.

  7. Depending on whether you want to recover the Db2 instance or to leave the instance in the rollforward pending state after the restore, select one of the following options, click Next, and then follow the instructions:

    Option Instructions
    Recover

    The Overwrite existing databases option is enabled by default and you cannot disable it. All the databases that belong to the Db2 instance will be overwritten.
    Leave in Rollforward Pending State

    The Overwrite existing databases option is enabled by default and you cannot disable it. All the databases that belong to the Db2 instance will be overwritten.

    Important  After leaving the databases in the rollforward pending state, you must complete the rollforward recovery for the Db2 instance. For instructions, see Db2 documentation.
  8. Click Restore.