Redirecting a restore of DB2 data

The instance that you are redirecting DB2 data to must already exist. Backup Exec does not create a new instance.

You cannot redirect restores of the DMS containers or SMS containers in the following situations:

To redirect a restore of DB2 data

  1. Create a restore job.

    See Restoring DB2 data.

  2. After you select options on the Restore Job Properties dialog box for DB2, on the Properties pane, under Destination, click DB2 Redirection.

  3. Select the appropriate options as follows:

    Redirect DB2 instance to server

    Check Restore DB2 instance to server to redirect the restore of the DB2 instance to a server other than the source server.

    Server

    Type the name of the server to which you want to redirect the restore job.

    Server logon account

    Type a logon account that has rights to restore data to the server to which you want to redirect the restore job.

    Redirect to a new instance

    Check Redirect to a new instance to redirect the restore of a database to another instance.

    The instance that you want to redirect to must already exist or the job fails.

    Instance

    Type the name of the instance to which you are redirecting the restore of the database.

    Instance logon account

    If you want to change the logon account, type a logon account for the database that you want to restore. This logon account must have backup operator or administrator privileges.

    Restore to a new database

    Check Restore to a new database to redirect the restore of the database to a new database other than the source server.

    Database name

    Type the name of the database to which you want to redirect the restore job.

    Drive to restore to

    Type a drive to which you want to redirect the DB2 database.

    Restore log location

    Specify the full path of the location where you want the log files for the new database to reside.

    Redirect containers

    Check Redirect containers to specify a different location for the DMS and/or SMS containers for the tablespaces or database that you want to restore.

    SMS tablespace container relative path

    Type the path to which you want to redirect the system managed space (SMS) table spaces containers.

    For example, you restore the tablespace TS1, which has the following SMS and DMS containers:

    C:\TS1Containers\SMS\SMSCONT001\

    C:\TS1Containers\SMS\SMSCONT002\

    C:\TS1Containers\DMS\DMSCONT001

    C:\TS1Containers\DMS\DMSCONT002

    You can redirect the SMS and DMS containers to different locations by typing the path for the SMS container as D:\TS1SMS\. Type the path for the DMS container as D:\TS1DMS\. When the tablespace is restored, the containers are restored as follows:

    SMS containers

    D:\TS1SMS\SMSCONT001\

    D:\TS1SMS\SMSCONT002\

    DMS containers

    D:\TS1DMS\DMSCONT001

    D:\TS1DMS\DMSCONT002

    DMS tablespace container relative path

    Type the path to which you want to redirect the database managed space (DMS) table space containers.

    See the example in the description of the SMS tablespace container relative path field.

  4. Start the redirected restore job or select other restore options from the Properties pane.

    After the restore job is complete, Symantec recommends that you run a full backup of the restored data.

More Information

About troubleshooting DB2