Subscription with bulk materialization

You can use dump and load or manual coordination methods to synchronize databases.

To create a database subscription using dump and load coordination, use define subscription with the use dump marker clause. Both the primary and replicate databases and Replication Servers, must have the same server user ID, password, and role settings.

define subscription sub_2
  for database replication definition repdef_1
    with primary at PDS.primary_db

  with replicate at RDS.rdb
  subscribe to truncate table
  use dump marker

After you define the subscription:

1. Dump PDS.pdb. The DSI connection to the replicate database is suspended when the dump marker reaches the replicate Replication Server. It is suspended so that no data will be replicated until you finished step 2. Replication Server activates and validates the subscription automatically when the dump marker is replicated.

   WARNING! Do not activate subscription or it will override the wait for dump marker at the Replication Server.

2. Load PDS.pdb to RDS.rdb.

3. Resume the DSI connection to the RDS.rdb.