Adds an alternate logical connection to the default logical connection. Replication Server uses logical
connections to manage warm standby applications.
Syntax
create alternate logical connection to logical_ds.logical_db
named conn_lds.conn_ldb
Parameters
logical_ds – The name of the logical data server in the default logical connection.
logical_db – The name of the logical database in the default logical connection.
conn_lds.conn_ldb – The name of the alternate logical connection.
If conn_lds is the same as logical_ds, conn_ldb must be different from logical_db.
Each alternate logical connection name—conn_lds.conn_ldb, must be unique among all alternate logical connection names in a replication system.
Examples
Example 1 – create an alternate logical connection named lds.conn_logicaldb2 to the logicaldb logical database in the LDS logical data server:
create alternate logical connection to LDS.logicaldb
named lds.conn_logicaldb2
Usage
You must create a default logical connection with create logical
connection before you can create alternate logical connections. See Replication Server
Administration Guide Volume 2 > Manage Warm Standby Applications > Setting Up ASE Warm Standby Databases > Task One: Creating the Logical Connection.
To create and configure alternate logical connections, see Replication Server
Administration Guide Volume 2 > Performance Tuning > Multi-Path Replication > Multiple Replication Paths for Warm Standby Environments.
You can use different Replication Servers to control the default logical connection and the
alternate logical connections. Both the active and standby databases must support having
multiple Replication Agents.
After you create an alternate logical connection, you can create alternate connections to the active and standby databases with create alternate connection.
Replication definitions and subscriptions use the
default logical connection name.
Permissions
create alternate logical connection requires “sa” permission.