Restoring DB2 MultiNode History Files

By default, the DB2 database will be in Offline mode. However, you need to set the database in online mode to restore the history files. You cannot restore history files which contain database records regarding recovery and administration events along with the log files. Hence, make sure to disable the restoring of log files and reapplying the logs (roll-forward) on restored database.

1. From the CommCell Browser, navigate to Client Computers > client > DB2MultiNode > instance.

2. Right-click the backup_set, point to All Tasks and then click Browse and Restore.

   The Browse and Restore dialog box is displayed.

3. On the Time Range tab, select Latest Backup and click View Content.

4. Select the databases to restore and click Recover All Selected.

   The Restore Options dialog box is displayed.

5. On the General tab, select the Restore Data check box and select the History Files option.

6. Click Advanced.

   The Advanced Restore Options dialog box is displayed.

7. On the Roll-Forward tab, clear the Roll-forward check box.

8. On the Log Files tab, clear the Restore Log Files check box.

9. Click OK to close the Advanced Restore Options dialog box.

10. Click OK to close the Restore Options dialog box.