DB2 redirection options

Article:HOWTO23617  |  Created: 2010-01-01  |  Updated: 2011-07-28  |  Article URL http://www.symantec.com/docs/HOWTO23617
Article Type
How To

Product(s)

Subject


DB2 redirection options

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.


Legacy ID



v19417023_be2010_adm


Article URL http://www.symantec.com/docs/HOWTO23617


Terms of use for this information are found in Legal Notices