Show TOC

create alternate logical connectionLocate this document in the navigation structure

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.