Logical Connection Information

The Database Setup Worksheet includes logical connection needed if you are adding a database that is part of a warm standby database application.

Setting up a warm standby application requires that you perform additional tasks in the Replication Server before and after you use rs_init to add the databases to the replication system.

To configure warm standby for Adaptive Server databases, see Replication Server Administration Guide Volume 2 > Manage Warm Standby Applications. To configure warm standby for Oracle databases, see Replication Server Heterogeneous Replication Guide > Heterogeneous Warm Standby for Oracle.

These are the worksheet fields:

Field Description
Is this an active connection or standby connection? (Required) Select Active if you are adding the active database for the warm standby application.

Select Standby if you are adding the standby database for the warm standby application.

Logical DS name (Required) The name of the logical data server for the logical connection. You must have already created it using create logical connection.
Logical DB name (Required) the name of the logical database for the logical connection. You must have already created it using create logical connection.

Complete the rest of the items in this section only if you have selected a standby connection over an active connection.

Active DS name (Required) The name of the data server with the active database. Enter the actual data server name, not the logical data server name defined for the warm standby database pair.
Active DB name (Required) The name of the active database. Enter the actual database name, not the logical database name defined for the warm standby database pair.
Active DB SA user (Required) The login name of the system administrator for the data server of the active database. Replication Server uses this login name to set up warm standby applications.
Active DB SA password (Required) The password for the system administrator login name of the data server of the active database.
Initialize standby using dump and load? (Required) Select Yes if you plan to initialize the standby database with the contents of the active database with the dump and load commands.

Select No if you plan to initialize the standby database with the bcp utility, or if you do not need to initialize the standby database.

Use dump marker to start replicating to standby? (Required) Select Yes if transactions will be executed in the active database while the standby database is initialized.