Restoring DB2 MultiNode Logs

Whenever log files are restored without reapplying the logs (roll-forward), the files are restored to the DB2 Retrieve Path that was specified during the 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, navigate to Client Computers | <DB2 MultiNode Client> | <Instance>.

2. Right-click the <BackupSet>, point to All Tasks and then click Browse and Restore.

3. Select Latest Backup and click View Content.

4. Select the database and click Recover All Selected.

5. On the Restore Options dialog box, click Advanced.

6. On the Log Files tab of the Advanced Restore Options dialog box.

   1. Select the Restore Log Files check box.

   2. To restore all logs, select All Log Files.

   3. To restore to a point-in-time, select By Point in Time andenter the Start and End check boxes to specify the point-in-time (date and time) for restoring the log files

   4. To restore to a specific log serial number, select By Log Serial Number and select the Start and End log serial numbers for restore.

   5. Click OK.

7. Click OK.