create alternate connection

Adds an alternate primary or replicate connection, or an alternate active or standby connection, and sets configuration parameters for the connection.

Syntax

create alternate connection to data_server.database
named conn_server.conn_db
[set error class [to] error_class]
[set function string class [to] function_class]
[set username [to] user]
[set password [to] passwd]
[set database_param [to] 'value' [set database_param [to] 'value']...]
[set security_param [to] 'value' [set security_param [to] 'value']...]
[with {log transfer on | primary only}]
[as {active | standby} for conn_lds.conn_ldb]

Parameters

data_server – the data server that holds the database to which you want to add an alternate primary or replicate connection.
database – the database to which you want to add an alternate primary or replicate connection.
conn_server.conn_database – the name of the alternate primary or replicate connection.
- For alternate replicate connections, if conn_server is different from dataserver, there must be an entry for conn_server in the interface file.
- If conn_server is the same as dataserver, conn_db must be different from database.
- Each primary connection name must be unique among all primary connection names in a replication system. Each replicate connection name must be unique among all replicate connection names in a replication system.
- To bind an alternate primary connection to an alternate Replication Agent path to create a primary replication path, conn_server.conn_db must match the name of the Replication Agent path from Replication Agent to Replication Server, and conn_server must be the same as dataserver
error_class – The error class that is to handle errors for the database.
function_class – The function string-class to be used for operations in the database.
user – The login name of the Replication Server maintenance user for the database for an alternate replicate connection. Replication Server uses this login name to maintain replicated data. You must specify a user name if network-based security is not enabled.
passwd – The password for the maintenance user login name. You must specify a password unless a network-based security mechanism is enabled.
database_param – A parameter that affects database connections from the Replication Server. You can use the same parameters that you use for alter connection or create connection.
value – A character string that contains a value for the option.
security_param – A parameter that affects network-based security. You can use the same parameters that you use for alter connection or create connection.
log transfer on – Instructs Replication Server to create an alternate primary connection and an alternate replicate connection to the database you specify in dataserver.database, with both primary and replicate alternate connections having the name you specify in conn_server.conn_db
primary only – Instructs Replication Server to create only an alternate primary connection to the primary database with the name you specify in conn_server.conn_db.
as {active | standby} for conn_lds.conn_ldb – Instructs Replication Server to create an alternate connection to either the active or standby database of a warm standby pair if you have created an alternate logical connection named conn_lds.conn_ldb

Examples

Example 1 – create an alternate primary connection named SALES_DS.pdb_conn2 to the pdb database in the SALES_DS data server:
```
create alternate connection to SALES_DS.pdb
named SALES_DS.pdb_conn2
with primary only
go
```
Example 2 – create an alternate replicate connection named FINANCE_DS2.rdb_conn2 to the rdb replicate database in the FINANCE_DS data server:
```
create alternate connection to FINANCE_DS.rdb
named FINANCE_DS2.rdb_conn2
go
```
Example 3 – create an alternate replicate connection called IQSRVR.lqdb_conn2 to the lqdb replicate database in the IQSRVR Sybase IQ data server where the primary database is Adaptive Server and dbmaint2 is the maintenance user for IQSRVR.lqdb_conn2:
```
create alternate connection to IQSRVR.iqdb
named IQSRVR.iqdb_conn2
using profile rs_ase_to_iq; standard
set username to dbmaint2
set password to dbmaint2pwd
go
```
You can also create alternate connections to available Sybase IQ multiplex nodes. Ensure that the connection names are unique.
To create the iqdb2_conn1 alternate connection to the iqbd2 database in the IQSRVR Sybase IQ node:
```
create alternate connection to IQSRVR.iqbd2
named IQSRVR2.iqdb2_conn1
using profile rs_ase_to_iq; standard
set username to dbmaint3
set password to dbmaint3pwd
go
```

Usage

set function string class, set username, and set password are existing clauses for alter connection and create connection that you can use when you create alternate connections.
- If you omit these clauses, the alternate replicate connection inherits the values that you set with the default replicate connection.
- If you omit these clauses when you create an alternate connection on a (current) Replication Server that is different from the (controller) Replication Server that controls the default connection, the current Replication Server returns an error.
- The alternate replicate connection can inherit values from the default connection only if the same Replication Server controls both default and alternate connections.
- If you do not set the maintenance user for the alternate connection, the connection inherits the default connection maintenance user. The alternate connection uses any new maintenance user that you specify for the alternate connection.
set database_param and set security_param are existing clauses for alter connection and create connection that you can use to specify existing optional connection parameters.
- Any value you set for the alternate connection overrides inherited values from the default connection or the default values.
- The alternate connection can inherit the values from the default connection only if the same Replication Server controls both alternate and default connections.
Execute create alternate connection at the Replication Servers that belong to the same replication domain that manages the database.
To create alternate logical connections for a warm standby application, use create alternate logical connection and create alternate connection.
Use alter connection to change the attributes of a connection. If the password of the maintenance user has been changed, use alter connection to enter the new password.
See Replication Server Administration Guide Volume 2 > Performance Tuning > Multi-Path Replication.

Permissions

create alternate connection requires “sa” permission.