Redirecting a DB2 Restore to a New Database

You can redirect a restore to a different database on the source host and same instance.

When you redirect a restore to a different database on the source host and same instance, ensure the following:

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

• Back up your subclient on the source database.

If you redirect a restore as part of the DB2 transaction log replication for standby database procedure, the standby database name (Restore Options dialog box, General tab, Target Database Name box) must be different than the production (source) database name.

The 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. On the Browse and Restore dialog box, select Latest Backup and then click View Content.

4. Select the database and click Recover All Selected.

   The Restore Options dialog box is displayed.

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

6. 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.

7. On the General tab, select the restore options.

   1. If this restore is for DB2 transaction log replication, clear the Restore Data check box, otherwise select the Restore Data check box and select Entire Database.

   2. Select the destination for the redirected restore from the Destination Computer list.

   3. In the Target Database Name, enter the target database name.

   4. In the Target Database path, type the location of the target database.

   5. Click Advanced.

      The Advanced Restore Options dialog box is displayed.

8. Specify the storage path if you have an automatic or mixed database, or the redirect information if you have a non-automatic database.

9. Database Type	Procedure
   Automatic or Mixed Databases	Note DB2 storage paths are displayed only if there are GUI backup jobs that have run for this database. You won't see storage paths displayed for third-party command line backup jobs. To specify the storage path, on the Storage Paths tab: Select the Redirect storage groups check box. The DB2 storage groups appear. From the Storage group box, select the DB2 storage group to view the existing path on the source database. In the Path box, select the path on the DB2 storage device. To change a path for this storage group, click it, then click Edit. Type the changes to the path. To add a path for this storage group, click Add, and then type the path.
   Non-Automatic Databases	To redirect tablespaces: On the Redirect tab: Select the Redirect All Table Spaces/Database to check box Enter the path to redirect the tablespaces and database. To redirect tablespace containers: On the Redirect tab: Select the Redirect All Table Space Containers check box. In the Table Space [Highwatermark] box, select the tablespace, and then click Add. The Browsing for Container Name dialog box appears. In the Name box, type the tablespace name. From the Type list, select the container path type, for example Disk Extent. In the Pages box, type the disk space for the container name. Each page is equivalent to 4KB. Click OK. The Browsing for Container Name dialog box closes.

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

11. Click OK to close the Restore Options dialog box.