Make a
copy of the rs_create_test_db_sub.sql script
namedmy_udb_rs_create_test_db_sub.sql.
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 IBM DB2 Universal Database.
{pdb} – name of the database of the primary IBM DB2 Universal Database.
{rds} – name of the DirectConnect service.
{rdb} – any valid identifier. Sybase recommends that you use the IBM DB2 Universal Database 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 Agentibmudb.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