Restoring a whole Db2 server

With R‑Cloud, you can restore a whole Db2 application to its original or a new location by restoring the virtual machine instance on which the Db2 application is hosted. Depending on how you want to restore your Db2 application, choose one of the following options:

I want to restore a Db2 application by... Restore option to select

Restoring the virtual machine instance on which the application is hosted to its original location.

 Restore VM Instance
Creating a clone of the virtual machine instance on which the application is hosted to the same or a different location on the same cloud platform. Clone VM Instance

Important  Before you start restoring your Db2 applications, make sure that you are familiar with all the prerequisites, limitations, considerations, and/or recommendations related to the instances on which these applications are hosted. For details, see Restoring instances.

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

Restore option Instructions

Restore VM Instance

  1. In the Applications panel, click the Db2 application that 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 Whole Db2 Server, and then click Next.

  5. Select Restore VM Instance, and then click Next.

  6. Follow the procedure as described in Restoring an instance.

  7. Run the following command for each restored database:

    db2 restart database <DatabaseAlias> write resume

Clone VM Instance

  1. In the Applications panel, click the Db2 application that 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 Whole Db2 Server, and then click Next.

  5. Select Clone VM Instance, and then click Next.

  6. Follow the procedure for your cloud platform as described in Cloning an instance.

  7. After cloning the virtual machine instance on which the Db2 application is hosted, the Db2 server host name changes and you must update the Db2 settings that reference the old host name. To do so, follow these steps:

    1. Update the DB2SYSTEM registry variable to match the new host name by using the db2set command.

    2. Change the entries of the host name in the db2nodes.cfg file to the new host name.

    3. Start the Db2 server.

    For instructions on how to perform these steps, see Db2 documentation.

  8. Run the following command for each restored database:

    db2 restart database <DatabaseAlias> write resume