Full System Recovery of DB2 MultiNode Database: Restoring the DB2 MultiNode Database

Restore and bring up each dropped database from its database backup image in the event of a disaster.

Before You Begin

Rebuild the Operating system

Procedure

  1. From the CommCell Browser, navigate to Client Computers | <DB2 MultiNode Client> | <Instance>.
  2. Right-click the <Backup Set>, point to All Tasks and then click Browse and Restore.
  3. Click View Content on the Browse and Restore Options dialog.
  4. In the right pane of the Browse window, select the databases you want to restore and click Recover All Selected.
  5. On the DB2 Restore Options dialog:
    1. On the General tab, check the Restore Data check box and select the Entire Database option.
    2. Navigate to the Recover tab and check the Restore Data check box .
    3. Click OK on the Warning dialog.
  6. Click OK.

    Monitor the progress of the restore job in the Job Controller.

  7. Once the restore job has completed, right-click the <Backup Set>, point to View, and then click Restore History
  8. Click OK.
  9. You can right-click the job and view the following details:
    • View Restore Items

      You can view them as Successful, Failed, Skipped or All.

    • View Job Details
    • View Events of the restore job
    • View Log files of the restore job
    • View number of objects

What To Do Next

Once the database is restored, verify that the restored database and log files are available in the original location.