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 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:
Dump PDS.pdb. The dump marker activates and validates the subscription. The DSI connection to the replicate database is suspended when the dump marker reaches the replicate Replication Server.
Load PDS.pdb to RDS.rdb.
Resume the DSI connection to the RDS.rdb.
