Loading...

CommCell Console Restores - Restoring to a New Host

You can rename and redirect one or more table spaces or table space containers to a different destination on the same or on different (cross-machine) host. The DB2 automatic storage database contains the automatic storage tablespaces, or a mix of both the automatic and non-automatic storage tablespaces. The DB2 non-automatic storage database contains the non-automatic storage tablespaces only.

When restoring to a new host, ensure the following:

  • Configure the source DB2 instance, backup set and subclient on CommCell console.
  • Configure the destination DB2 Instance on CommCell console.
  • Back up your subclient on Source client.

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

Use the following steps to redirect a restore to a new host:

  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 General tab.
    1. Select the Restore Data check box.
    2. Select the Entire Database option.
    3. Select the destination client name from the Destination Computer list.
    4. If you choose to change the instance, select the Destination Instance from the destination instance list.
    5. To change the target database name and location, type the Target Database Name. Enter the location.

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

    6. Click Advanced.

      The Advanced Restore Options dialog box is displayed.

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

    On the Storage Paths tab:

    1. Select the Redirect storage groups check box.

      The software displays the DB2 storage groups.

    2. In 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 edit an existing path, click Edit, and then in the dialog box specify the path on the destination.
      • To add a new path, click Add, and then in the dialog box specify the path.
      •  

    Non-Automatic Databases

    On the Redirect tab:

    1. Select the Redirect All Table Spaces/Database to check box
    2. Enter the path to redirect the tablespaces and database.

      Note: The path must contain 'SQL0001.

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

Last modified: 7/31/2018 11:51:50 AM