Creating Alternate Replicate Connections to SAP IQ

Use create alternate connection with the using profile clause to create an alternate connection from Replication Server to the replicate SAP IQ database.

Prerequisites

Create the default connection to the replicate database before you create any alternate connections.

Task

You must specify the connection profile and connection profile version, and a unique maintenance user name for the default and each alternate connection.

Create an alternate connection to the SAP IQ replicate database:

create alternate connection to dataserver.database
named conn_server.conn_db
using profile connection_profile;version 
set username [to] user
set password [to] pwd

where:

dataserver and database – are the replicate data server and database.
conn_server.conn_db – the alternate replicate connection, which comprises the data server name and a connection name.
- Each replicate connection name must be unique in a replication system.
- 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.
connection_profile – specifies the correct function-string class and error class for the replicate database, and additionally may contain class-level translation definitions and support for replicate database object creation:
- rs_ase_to_iq – for Adaptive Server to SAP IQ replication
- rs_oracle_to_iq – for Oracle to SAP IQ replication
Note: You must specify the connection profile for each alternate connection you create to an SAP IQ database.
version – the connection profile version to use
Note: You must specify the connection profile version for each alternate connection you create to an SAP IQ database
user – login name of the Replication Server maintenance user for each connection to the SAP IQ database. Replication Server uses this login name to maintain replicated data. You must specify a user name if network-based security is not enabled.
Note: You must use a different maintenance user name for each alternate connection you create to an SAP IQ database. Ensure that you use unique maintenance user names even if you are creating connections from different Replication Servers to an SAP IQ database. If you do not use unique user names, data duplication errors may occur. The replication system cannnot detect if you use the same user name to create connections from different Replication Servers.

For example, to create an alternate replicate connection named IQSRVR.iqdb_conn2 to the iqdb replicate database in the IQSRVR SAP IQ data server where the primary database is Adaptive Server and dbmaint2 is the maintenance user for IQSRVR.iqdb_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