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

You can redirect a restore to a different DB2 instance on the source host. When redirecting a restore to a different DB2 instance on the source host, ensure the following:

• Configure the source DB2 instance, backup set and subclient on the CommCell Console.

• Configure the destination DB2 Instance on the CommCell console.

• Back up your subclient on the source instance.

Note: The Commvault software automatically creates the target DB2 database when it does not exist.

To view the DB2 tablespace high water mark for all backups, see Setting the Software to Store the DB2 Tablespace High Water Mark.

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.

3. The Browse and Restore dialog box is displayed.

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

5. Select the databases to restore and click Recover All Selected.

   The Restore Options dialog box is displayed.

6. On the General tab, select the data to restore.

   1. Select the Restore Data check box and click the Entire Database option.

   2. Select the tablespaces from the Latest Database View list.

   3. Select the Destination Instance from the destination instance list to change the instance on the source host.

   4. To change the target database name and location, type the Target Database Name and enter the path in the Target Database Path box

      For a Windows client, the Target Database Path is with a drive letter.

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. On the Redirect tab:

   To redirect tablespaces:

   1. Select the Redirect All Table Spaces/Database to check box

   2. Enter the path to redirect the tablespaces and database.

   To redirect tablespace containers:

   1. Select the Redirect All Table Space Containers check box.

   2. In the Table Space [Highwatermark] box, select the tablespace, and then click Add.

      The Browsing for Container Name dialog box appears.

   3. In the Name box, type the tablespace name.

   4. From the Type list, select the container path type, for example Disk Extent.

   5. In the Pages box, type the disk space for the container name. Each page is equivalent to 4KB.

   6. Click OK.

      The Browsing for Container Name dialog box closes.

10. Click OK.

11. Click OK.