V11 SP8

Restoring a DB2 Backup to the Same Host

To restore a database, you must deactivate it. When you deactivate the database, all the DB2 non-administrative users are disconnected. The system automatically activates the database after the restore operation. After the restore operation, connect the non-administrative users.

When the database is corrupted or lost, you can restore and recover it from the latest offline or online full backup (depending on how the subclient was configured for backup operations).

By default, the database is restored to the same location from where it was backed up. After you restore the database, it is recovered to the current time.


  1. From the CommCell Browser, expand Client Computers > client > DB2 > instance.
  2. Right-click the backup_set, point to All Tasks, and then click Browse and Restore.

    The Browse and Restore dialog box appears.

  3. On the Time Range tab, select Latest Backup, and then click View Content.
  4. Select the databases to restore, and then click Recover All Selected.

    The Restore Options dialog box appears.

  5. On the Recover Database tab, select the following options:
    1. Select the Recover DB check box.
    2. Select the To the End of the logs option.
  6. Optional: Restore from a copy precedence:
    1. Click Advanced.

      The Advanced Restore Options dialog box appears.

    2. On the Copy Precedence tab, select the Restore from copy precedence check box. From Copy Precedence list, select the number.
    3. Click OK.
  7. Click OK to close the Restore Options dialog box.