Recovering a DB2 MultiNode Database

By default, you can recover the database along with the restore operation. However, you cannot recover a partial database. Also, you will not be able to recover a database while performing an out-of-place restore operation. If you are trying to recover the database using the backup image, you will not be able to reapply the logs for restore.

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 Recover tab, select the Recover DB check box.

6. Select the recover option.

   Recover to the end of the logs

   1. Select the To the End of the logs option

   2. Click Advanced.

      The Advanced Restore Options dialog box is displayed.

   3. On the Roll-Forward tab, select the To the End of the logs check box.

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

   Select the All Log Files option.

   Recover to a point-in-time

   Select By Point in Time and enter the Start and End time in the boxes.

7. Optional: Use a history path.

   The software checks the history file for the backup image to restore. If the history file is not available, restore the history file before you recover the database. If the software does not find all of the information that it needs in the history file path, it looks in the overflow directory. Use this overflow directory path only if you moved log files to a location other than the directory specified by the logpath database configuration parameter.

   1. Select the History File Path check box.

   2. Enter the full path to the history file in the box

   3. Enter the full path to the overflow directory in the Overflow Directory box.

8. Optional: Run scripts before or after the restore.

   Enter the full path for the pre-recovery and post-recovery script.

   You can choose to run the post-process script even if the restore job failed.

   1. Click Advanced.

      The Advanced Restore Options dialog box is displayed.

   2. On the Pre/Post tab:

      • In the Pre-Recovery Command box, type the full path name for the script.

      • In the Post-Recovery Command box, type the full path name for the script.

      • To run the post recovery process regardless of the job's outcome, select the Run Post Process for all attempts check box.

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

9. Click OK to close the Restore Options dialog box and start the restore.