Creating the connection to RepConnector

A data connection defines the information that Replication Server uses to connect to RepConnector for replicating data. The following procedure adds the RepConnector connection to the replication system and sets the configuration parameters for the connection.

Before creating the connection

Before you can create the connection, you must gather the following information:

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

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

Using the isql utility, log in to the Replication Server with the user ID that has System Administrator permission:

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.

Using the create connection command, 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; for example, RepConnector.
database is the name of the database to which you are replicating. However, RepConnector does not use the database name; the database name here is a placeholder to meet Replication Server syntax requirements.

Because a RepConnector connection is the destination instead of an actual database, Sybase recommends you use a name that is unique and that represents the RepConnector connection.

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, if you use a name that clearly designates the replicate or destination, in this case, RepConnector, it might help you 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.

Record this value in 3.j on the worksheet. For example, 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. Therefore, you must set the batch and dsi_xact_group_size parameters to disable batching of commands for the connection to RepConnector. If you have already created the connection, you can use the configure connection and alter connection commands to set the batch and dsi_xact_group_size parameters. See the Replication Server Reference Manual for the exact syntax of the configure connection and alter connection commands.

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