> CommCell Console > Backup and Restore Agents > Databases > DB2 > DB2 Backup Administrator Guide > CommCell Console DB2 Restores > Restoring and Recovering an Entire DB2 Database to a New Host

Redirecting Automatic and Non-Automatic Storage Tablespaces on a Mixed Database

If a mix of both the automatic and non-automatic storage tablespaces exists in your DB2 automatic storage database, you can redirect both automatic and non-automatic tablespaces or tablespace containers to a new destination computer.

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

Use the following steps to change the storage paths for automatic table spaces and redirect the automatic table spaces:

  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 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 click Recover All Selected.

    The Restore Options dialog box is displayed.

  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. Click Advanced.

    The Advanced Restore Options dialog box is displayed.

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

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:

  1. Select the Redirect storage groups check box.

    The DB2 storage groups appear.

  2. From the Storage group box, select the DB2 storage group to view the existing path on the source database.

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

On the Redirect tab:

  1. To redirect all tablespaces to specific location, select the Redirect All Table Spaces/Database to check box and enter the path in the box.

  2. If Redirect Table Space Containers check box is selected:

    1. To redirect a individual tablespace, select the Container name and click Edit.

    2. In the Editing Container Name for table space dialog box, specify a new path in Name box. Add the container name after the path in the text box of Edit Container Name of Table Space box. Select the container type from the Type dropdown list.

      Note

      The user can select either Redirect All Tablespaces/Database to or Redirect Table Space Containers option. Always use redirect restore by performing a new Browse and Restore, and avoid resubmitting previous redirect restore jobs.
  1. Click OK to close the Advanced Restore Options dialog box.

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

×

Loading...