Creating a Replication Server connection to replicate
Navigate to the $SYBASE/RAX-15_2/scripts/ibmudb (UNIX or Linux) or %SYBASE%\REP-15_2\scripts\ibmudb directory.
Make a copy of the udb_create_rs152_standby_connection.sql script named my_udb_create_rs152_standby_connection.sql.
Before executing the my_udb_create_rs152_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 in ECDA Option for ODBC, in step 2 of “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
In the above example, password is
a Replication Server reserved word and, therefore, must be enclosed
in double quotes.
Create the connection to the replicate database:
isql –Usa –P –SSAMPLE_RS -i my_udb_create_rs152_standby_connection.sql
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.”
Exit the isql session with the quit command.
