Creating the connection to RepConnector

A RepConnector connection defines the information that Replication Server uses to connnect to the RepConnector server, to replicate data.

Before you create the connection, gather the following information:

The location of the isql utility, which is in the Replication Server installation directory under OCS-15/bin on UNIX, or OCS-15\bin on Windows

The DSI name for the RepConnector connection (from line 3.a on your worksheet; it is also the same name added to the interfaces file)

A user name to connect to the RepConnector connection (from line 3.e on your worksheet)

A password for this user name (from line 3.f on your worksheet)

Creating a new RepConnector connection in Replication Server

isql -U <username> -P <pwd> -S <server_name>

where:

username is the user ID with sa permission in the Replication Server.
pwd is the password for the user ID.
server_name is the server name of the Replication Server.

Create the connection, and define the user ID and password for the RepConnector connection:

             create connection to <dataserver>.<database>
             set error class to rs_sqlserver_error_class
             set function string class to rs_sqlserver_function_class
             set username <dsi_username>
             set password <dsi_password>
             set batch to 'off'
             set dsi_xact_group_size to '-1'
             with dsi_suspended

where:

dataserver is the RepConnector connection’s DSI name. This is the same name you added to the Replication Server interfaces file. Use the name recorded in 3.a on your worksheet.
database is the name of the database to which you are replicating. Record this value in 3.j on the worksheet.

When you create this connection in Replication Server, you must designate it with the dataserver.database data pair value. However, the database name in Replication Server is just a placeholder, and RepConnector does not use that name. Therefore, use a name that clearly designates the replicate or destination (in this case RepConnector), to manage the RepConnector connection in an environment where you are also managing traditional Replication Server connections, whose destinations are actually databases. For example, designate the connection as RepConnector.RepCondb.
dsi_username is the user ID that is used to connect to the RepConnector connection. Use the value recorded in 3.e on your worksheet.
dsi_password is the password for the user ID. Use the value recorded in 3.f on your worksheet.
set batch to 'off' is required by RepConnector. This instructs Replication Server not to batch the commands to send to RepConnector.
set dsi_xact_group_size to '-1' is required by RepConnector. This instructs Replication Server not to group the transactions as a single transaction before sending them to RepConnector.

RepConnector does not support the batching of commands in Replication Server. If you have already created the connection, and have not set the batch and dsi_xact_group_size parameters as indicated above, use the configure connection and alter connection commands to set them. See the Replication Server Reference Manual.

For example:

create connection to RepConnector.RepCondb set error class to rs_sqlserver_error_class set function string class to rs_sqlserver_function_class set username sa set batch to 'off' set dsi_xact_group_size to '-1' with dsi_suspended