This section describes the required configurations for Replication Server for replication to the target IBM DB2 Universal Database data server.
To create a Replication
Server connection to replicate
Navigate to the Replication Server scripts $SYBASE/REP-15_0/scripts directory:
Make a copy of the hds_udb_connection_sample script:
cp hds_udb_connection_sample.sql my_udb_rs_create_repl_connection.sql
Before executing the my_udb_rs_create_repl_connection.sql script against your Replication Server, change the name of the connection that Replication Server uses to connect to DirectConnect server, where:
udb_dcudb.udb_dcudb is the DirectConnect server 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 DCOServer.my_udb_db set error class rs_sqlserver_error.class set function string class rs_udb_function_class set username maintuser set password “password” set batch to “off” 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_rs_repl_connection.sql
To verify the Replication Server connection to the replicate database, 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.
