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:

StepsTo reset the primary database for replication

  1. Login into the Replication Agent and issue the suspend command:

    suspend
    
    go
    
  2. Zero-out the locator stored in the Replication Agent by using the ra_locator command:

    ra_locator zero
    
    go
    
  3. 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)
    
  4. Resume replication:

    resume
    
    go