Creating a Database Replication Subscription

Create a database replication subscription.

1. Make a copy of the rs_create_test_db_sub.sql script named 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} – name of the data server of the primary DB2 UDB database.
   • {pdb} – name of the database of the primary DB2 UDB database.
   • {rds} – name of the DirectConnect service.
   • {rdb} – any valid identifier. SAP recommends that you use the DB2 UDB replicate database name.

   Note: Save the values of pds and pdb to be used later for the rs_source_ds and rs_source_db parameters in the Replication Agent ibmudb.rs file.
   Here is an example of how to create a database replication subscription:

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

3. Connect to the Replication Server and enter:
   

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

   You see a message indicating that the subscription is being created.