Resetting the Primary IBM DB2 Universal Database for Replication

Learn how to reset 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 task to facilitate resetting the environment.

Log in to the Replication Agent and issue:
```
suspend
```
```
go
```
Reset the locator stored in the Replication Agent:
```
ra_locator zero
```
```
go
```

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

You see:

Locator has been reset to zero.

(return status = 0)

Resume replication:
```
resume
```
```
go
```