Configuring Replication Server for replication from the primary database

This section describes the configuration steps required for replication from the primary database. It includes:

• Creating a Replication Server connection to the primary database

• Creating a database replication definition

• Creating the database replication subscription

1. Go to the Replication Agent scripts directory at $SYBASE/RAX-15_1/scripts/sybase:

2. Make a copy of the rs_create_test_primary_connection.sql script:

   cp rs_create_test_primary_connection.sql
   my_udb_rs_create_test_primary_connection.sql
   

3. Before executing the my_udb_rs_create_test_ primary_connection.sql script against your Replication Server, change all occurrences of value {rax}.{test} to the name of the Replication Server connection between it and Replication Agent for UDB, where:

   • rax is rs_source_ds (located in $SYBASE/RAX-15_1/init/ibmudb.rs).

   • test is rs_source_db (located in $SYBASE/RAX-15_1/init/ibmudb.rs).

   You must save the defined values to be used for the Replication Agent ibmudb.rs file later in the process.

   For example, NY.NYudb9.

4. Change sys and sys_pwd to the user ID and password of the IBM DB2 Universal Database user who must have permission to apply DML operations against all user tables to be replicated, where:

   • sys is the user ID of the IBM DB2 Universal Database user (sys).

   • sys_pwd is the password of the IBM DB2 Universal Database user (change_on_install).

   This user must be a valid user in the IBM DB2 Universal Database.

   The following command creates a Replication Server connection to the primary database example:

   create connection to NY.NYudb9
   set error class rs_sqlserver_error_class
   set function string class rs_udb9_function_class
   set username sys
   set password change_on_install
   with log transfer on, dsi_suspended 
   go
   

5. Execute this script in Replication Server:

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

   A message is displayed that indicates the Replication Server connection to the primary database is created.

1. Navigate to the $SYBASE/RAX-15_1/script/sybase directory:

2. Make a copy of the rs_create_test_db_repdef.sql script:

   cp rs_create_test_db_repdef.sql
   my_udb_rs_create_test_db_repdef.sq
   

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 rs_source_ds (located in $SYBASE/RAX_15_1/init/ibmudb.rs).

   • pdb is rs_source_db (located in $SYBASE/RAX_15_1/init/ibmudb.rs).

   For example, NY.NYudb9.

   This 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
   

   A message is displayed that indicates the database replication definition is created.

1. Make a copy of the rs_create_test_db_sub.sql script:

   cp rs_create_test_db_sub.sql
   my_udb_rs_create_test_db_sub.sql
   

2. Before executing the my_udb_rs_create_test_db_sub.sql script, change the “{pds}.{pdb}” and “{rds}.{rdb}'”to the appropriate connection name, where:

   • pds is rs_source_ds (located in $SYBASE/RAX_15_1/init/ibmudb.rs).

   • pdb is rs_source_db (located in $SYBASE/RAX_15_1/init/ibmudb.rs).

   • rds is the DirectConnect server name

   • rdb is any valid identifier. (Sybase recommends that you use the IBM DB2 Universal Database replicate database name.)

   Here is an example of create database replication subscription:

   create subscription NY_sub1
   for database replication definition NY_repdef1
   with primary at NY.NYudb9
   with replicate at DCOServer.udb_db
   without materialization
   go
   

3. Connect to Replication Server and execute:

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

   A message is displayed that indicates the subscription is in the process of being created.