Migrating Replication Agent when UDB is upgraded from version 8.2 or 9.1 to version 9.5

This section describes how to migrate Replication Agent from version 15.0 or later to the current version while upgrading UDB from version 8.2 or 9.1 to version 9.5.

Migrating Replication Agent when upgrading UDB

To prevent any loss of replicated data, deny further access to users (other than the previously existing Replication Agent pds_username user) to the primary UDB database.

Log in to the Replication Agent 15.5 instance, verify that it is in Replicating state, and allow replication to finish. To verify that replication has completed:

Periodically issue the ra_statistics command, watching until all of the following statistics are zero (0):
- Input queue size
- Output queue size
When all of these values are zero, note the Last QID Sent from the last set of statistics.
Issue the ra_locator update command so that Replication Agent retrieves the truncation point from Replication Server.
Wait, then issue the ra_locator command again and compare the displayed locator with that of the Last QID Sent. If they are different, wait and repeat this step.
Quiesce the Replication Agent instance by issuing the quiesce command.
Shut down the Replication instance by issuing the shutdown command.

Follow the steps in the UDB documentation for upgrading UDB.

Verify that all the primary database requirements are met as described in “UDB Requirements” on page 110.

If the use_rssd configuration parameter was set to true before migration, skip the following step.
Start the Replication Agent instance, and set the use_rssd configuration parameter to true:
```
ra_config use_rssd, true
```
Replication Agent for UDB uses this configuration to connect to the RSSD and to reset the locator to zero.
Migrate the Replication Agent metadata by issuing the ra_migrate command.

If the use_rssd configuration parameter was set to true before migration, skip the following step.
In the Replication Agent 15.5 instance, resume replication by issuing the resume command.
Allow all users to access the primary UDB database.

If you are upgrading Replication Agent and upgrading UDB from version 8.2 or 9.1 to version 9.5 at the same time, you need to migrate Replication Agent only once.