Configuring Replication Server for Replication to the Target Data Server

Create a Replication Server connection to the replicate data server.

1. Navigate to the $SYBASE/RAX-15_5/scripts/ibmudb (UNIX or Linux) or %SYBASE%\REP-15_5\scripts\ibmudb directory.
2. Make a copy of the udb_create_rs_standby_connection.sql script named my_udb_create_rs_standby_connection.sql.
3. Before executing the my_udb_create_rs_standby_connection.sql script against your Replication Server, change the name of the connection that Replication Server uses to connect to the DirectConnect service, where:
   • {rds}.{rdb} is the DirectConnect service name followed by the replicate database name.
   • rs_maint_user and rs_maint_user_pwd are the maintenance user and password created while configuring ECDA Option for ODBC.
   For example:

   create connection to DCService.my_udb_db
   using profile rs_udb_to_udb;standard
   set username maintuser
   set password “password”
   go

   Note: In the above example, password is a Replication Server reserved word and, therefore, must be enclosed in double quotes and should match the password specified in the resource file.
4. Create the connection to the replicate database:

   isql –Usa –P –SSAMPLE_RS -i my_udb_create_rs_standby_connection.sql

5. Log in to SAMPLE_RS and verify the Replication Server connection to the replicate database:

   isql –Usa –P –SSAMPLE_RS
   admin who
   go

   You should see a message returned for the DSI connection {rds}.{rdb}. Verify that the status is “Awaiting Message” or “Awaiting Command.”
6. Exit the isql session with the quit command.