In a test environment, you may occasionally need to reset the replication environment. Instead of deleting and re-creating a new Replication Agent instance, use this procedure to facilitate resetting the environment:
To reset the primary database for replication
Login into the Replication Agent and issue the suspend command:
suspend
go
Zero-out the locator stored in the Replication Agent by using the ra_locator command:
ra_locator zero
go
Zero-out the locator stored in Replication Server using the rs_zeroltm command, for example:
isql -USAMPLE_RS_RSSD_prim -PSAMPLE_RS_RSSD_prim_ps -SSAMPLE_RS_ERSSD -DSAMPLE_RS_ERSSD rs_zeroltm NY, NYudb9 go
This message is displayed:
Locator has been reset to zero. (return status = 0)
Resume replication:
resume
go