Configure resynchronization for Adaptive Server databases.
Stop replication processing
by suspending RepAgent.
Instruct Replication Server to be in resync mode. While in
resync mode, Replication Server skips transactions and purges replication
data from replication queues in anticipation of the replicate database
being repopulated from a dump taken from the primary database or
trusted source.
Restart RepAgent and send a resync database
marker to Replication Server to indicate that a resynchronization
effort is in progress.
Verify that DSI receives the resync database marker.
Obtain a dump from the primary database.
When Replication Server detects a dump marker that indicates
the completion of the primary database dump, Replication Server
stops skipping transactions and can determine which transactions
to apply to the replicate database.
Verify that DSI receives the dump database marker.
Note: Sending a dump database marker does not apply in cases where you send the resync marker with the init instruction.
Apply the dump to the replicate database.
Resume replication.
You must use commands and parameters from both Replication
Server and RepAgent for database resynchronization.
Instructing Replication Server to Skip Transactions
Use the skip to resync parameter with the resume connection command to instruct Replication Server to skip transactions in the DSI outbound queue for the specified replicate database until Replication Server receives and acknowledges a dump database marker sent by RepAgent.