Loading...

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

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 SnapProtect 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 Out-of-place Snap Db Restore check box.
    2. Select the Restore Data check box.
    3. Select the Entire Database option.
    4. From the Destination Computer list, select the destination client name.
    5. From the Destination Instance list, select the destination instance.
    6. To change the target database name, type the new name in the Target Database Name box.
    7. To change the target database location, type the new path in the Target Database Path box.
    8. Click Advanced.

      The Advanced Restore Options dialog box appears.

  7. If you have an automatic database, select the storage path. If you have a non-automatic database, select the redirect information..
    Database Type Procedure
    Automatic database On the Storage Path tab, compete the following steps:
    1. Select the Storage Paths check box.
    2. Select the existing paths in the box, and then click Delete.
    3. To browse to the target database paths, click Browse. To manually enter the paths, click Add Paths.
    Non-automatic databases On the Redirect tab, compete the following steps:
    1. Select the Redirect All Table Spaces/Database to check box.
    2. To redirect the tablespaces and database, enter the path.

      Note: The path must contain 'SQL0001'.

  8. 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.
  9. Click OK.