Redirecting a DB2 Restore to a Different DB2 Instance on the Same Host

You can redirect a restore to a different DB2 instance on the client where you performed the backup.

The following rules apply to the Target Database Path:

• For both Windows and UNIX configurations, the Target Database Path must reside on a LUN device.

• The Target DB Path, Redirect Path, and the Storage Path parameter values must match each other exactly.

• The software overwrites any existing destination databases that are in the Target Database Path with the source database SQLDBDIR information.

For Windows configurations, the Target Database Path must start with a drive letter followed by the folder name (for example, 'E:\folder_name'). 'E:\folder_name').Note: If you want to restore to a new host and use the DB2 Advanced Copy Services (ACS) feature, the destination instance name and the destination database name must match the source instance name and the database name. The destination database must be in the same location as the source database.

If the destination DB2 database does not exist, then the Commvault software automatically creates it.

Before You Begin

1. Create and configure a DB2 instance on the CommCell Console at the source and destination clients.

2. Perform a full backup.

Procedure

1. From the CommCell Browser, expand 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 appears.

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

4. Optional: Use non-default browse and restore options. See Browse and Restore.

5. From the Browse window, select the data to restore in the right pane, and then click Recover All Selected.

   The Restore Options dialog box appears.

6. On the General tab, select the following options:

   1. Select the Restore Data check box.

   2. Select the Entire Database option.

   3. From the Destination Computer list, select the destination client name.

   4. From the Destination Instance list, select the destination instance.

   5. To change the target database name, type the new name in the Target Database Name box.

   6. To change the target database location, type the new path in the Target Database Path box.

7. On the Restore Arguments tab, in the Backup Images area, choose an option for selecting backup images:

   • To let the Commvault software select the latest backup images or the latest point-in-time backup images, based on the choice you made on the Time Range tab on the Browse and Restore dialog box, choose Auto Pick Backup Images.

   • To manually select a cycle of backup images, choose Select Backup Images. Select the images from the Available Images box, and then click > to move the selected images to the Selection box.

8. Click Advanced.

   The Advanced Restore Options dialog box appears.

9. If you have an automatic or mixed database, select the storage path. If you have a non-automatic database, select the redirect information.

   Database Type	Procedure
   Automatic or mixed database	On the Storage Paths tab: Select the Redirect storage groups check box. The DB2 storage groups are displayed. In the Storage group box, select the DB2 storage group to view the existing path. In the Path box, select the path on the DB2 storage device. To edit an existing path, click Edit, and then in the dialog box specify the path. To add a new path, click Add, and then in the dialog box specify the path.
   Non-automatic database	On the Redirect tab, complete the following steps: Select the Redirect All Table Spaces/Database to check box. To redirect the tablespaces and database, enter the path. Note The path must contain 'SQL0001'.

10. If you have an automatic database, on the General tab, in the Target Database Path box, type the path that you entered on the Storage Path tab of the Advanced Restore Options dialog box.

11. Click OK.

12. Click OK.