Recovering a DB2 MultiNode Database by Reapplying the Logs (Roll-forward)

You can recover the database by reapplying the log files containing transactions that are not part of any database backup image. The roll-forward capability is applied after a database or table space image is restored.

Whenever log files are restored with the roll-forward capability, DB2 searches for the following target restore paths:

• DB2's own directory path for log file restores

• The retrieve Path that was specified during the installation of the DB2 iDataAgent

• The archive Path that was specified during the installation of the DB2 iDataAgent

• The path identified (if any) in the Overflow Directory field within the Roll-Forward.

If it is unable to find any of these paths, the appropriate error is reported in a file within the DB2 Audit Error Path that was specified during installation of the DB2 iDataAgent.

The Commvault software waits 2 minutes for the IntelliSnap operation to complete. If the job does not complete when this time expires, the Commvault software marks the job as failed and brings the database out of the quiesced state. You can set this to a higher value to allow more time for the job to complete. For more information, see Configuring the time the Commvault Software Waits for the IntelliSnap Operation.

Procedure

1. From the CommCell Browser, expand Client Computers > client > DB2 MultiNode >instance.

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

3. From the Browse window, select the tables to restore and click Recover All Selected.

   The Restore Options dialog box is displayed.

4. On the Recover Database tab, clear the Recover DB check box.

5. Click Advanced.

   The Advanced Restore Options dialog box is displayed.

6. On the Roll-Forward tab.

   1. Select the Roll-forward (Reapply the Logs) check box.

   2. Select the Alternate Log Path check box.

   3. Enter the alternative location within the DB2 directory for the log files.

   4. If the client is in a different time zone from the CommServe computer, select the destination time zone from the Time Zone list.

   5. Click OK.

7. Click OK.