You can redirect DB2 data to another instance provided the instance already exists.
See Redirecting a restore of DB2 data.
The following table describes the Redirection options available for DB2:
Table: DB2 redirection options
|
Item
|
Description
|
|
Redirect DB2 instance to server |
Redirects the restore of the DB2 instance to a server other than the source server.
|
|
Server |
Specifies the name of the server to which you want to redirect the restore job.
|
|
Server logon account |
Specifies 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 |
Redirects the restore of a database to another instance.
The instance that you want to redirect to must already exist or the job fails.
|
|
Instance |
Specifies the name of the instance to which you are redirecting the restore of the database.
|
|
Instance logon account |
Specifies the 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 |
Redirects the restore of the database to a new database other than the source server.
|
|
Database name |
Indicates the name of the database to which you want to redirect the restore job.
|
|
Drive to restore to |
Indicates a drive to which you want to redirect the DB2 database.
|
|
Restore log location |
Specifies the full path of the location where you want the log files for the new database to reside.
|
|
Redirect containers |
Specifies 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 |
Indicates 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 |
Indicates 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.
|
DB2 redirection options