Resetting the Primary DB2 UDB Database for Replication

In a test environment, you may occasionally need to reset the replication environment.

  1. Log in to the Replication Agent and issue:
    isql -Usa -Psa_pass -Smyra
suspend
go
  2. Reset the locator stored in the Replication Agent:
    ra_locator zero
go
  3. Reset the locator stored in Replication Server:
    isql -Usa -Psa_pass -SSAMPLE_RS
connect
go
rs_zeroltm pds, pdb
go
exit
    You see:
    Locator has been reset to zero.
(return status = 0)
  4. Resume replication with the Replication Agent resume command:
    isql -Usa -Psa_pass -Smyra
1> resume
2> go
Parent topic: Testing Replication