Creating a Database Replication Definition

Create a database replication definition.

1. Navigate to the %SYBASE%\RAX-15_5\scripts\sybase (Windows) or $SYBASE/RAX-15_5/scripts/sybase (UNIX or Linux) directory.
2. Make a copy of the rs_create_test_db_repdef.sql script named my_udb_rs_create_test_db_repdef.sql.
   
3. Before executing the my_udb_rs_create_test_db_repdef.sql script, change the value of {pds}.{pdb} to the name of the connection string you defined for the primary database, where:
   • pds is the name of the data server of the primary IBM DB2 Universal Database.
   • pdb is the name of database of the primary IBM DB2 Universal Database

   For example, NY.NYudb9.

   Note: Save these values to be used later for the rs_source_ds and rs_source_db parameters in the Replication Agent ibmudb.rs file.

   Here is a database replication definition example:

   create database replication definition NY_repdef1
   with primary at NY.NYudb9
   go

4. Connect to the Replication Server and enter:
   

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

   You see a message indicating that the database replication definition has been created.