Resetting the primary IBM DB2 Universal Database for replication

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.

1. Log in to the Replication Agent and issue:

   suspend
   

   go
   

2. Reset the locator stored in the Replication Agent:

   ra_locator zero
   

   go
   

3. Reset the locator stored in Replication Server:

   isql -USAMPLE_RS_RSSD_prim -PSAMPLE_RS_RSSD_prim_ps
   -SSAMPLE_RS_ERSSD -DSAMPLE_RS_ERSSD
   

   rs_zeroltm NY, NYudb9
   

   go
   

   This message appears:

   Locator has been reset to zero.
   

   (return status = 0)
   

4. Resume replication:

   resume
   

   go