Restoring DB2 Logs by Using the LOGTARGET Option

You can use the DB2 LOGTARGET option to extract files from the backup image and restore them to the following directory.

UNIX

 
DB2_Retrieve_Path/db2_instance_name/db2_database_name/LogsFromBackupImage/

Windows

 
DB2_Retrieve_Path\db2_instance_name\db2_database_name\LogsFromBackupImage\

The DB2 Retrieve Path that you can specify during installation or that you configure with an additional setting.

For additional information on LOGTARGET, go to the DB2 Knowledge Center, LOGTARGET.

Before You Begin

By default, the Commvault software cleans the log target directory after the restore completes. To leave the log files in the target directory, to the DB2 client, add the additional setting as shown in the following table.

For instructions on how to add additional settings from the CommCell Console, see Add or Modify an Additional Setting.

Procedure

1. From the CommCell Browser, navigate to 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 is displayed.

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 is displayed.

5. On the Recover tab, clear the Recover DB check box.

6. On the Restore Arguments tab, in the Backup Images area, select the backup images from the available images, and then click >.

7. Click Advanced.

   The Advanced Restore Options dialog box is displayed.

8. On the Log Files tab, select the Restore Logs from Backup Image (use LogTarget) check box.

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

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