This section describes how to migrate Replication Agent for UDB 15.1 when you upgrade IBM DB2 Universal Database from version 8 to version 9.
To migrate Replication Agent when upgrading UDB
8 to 9
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.1 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):
Operation queue size
Operation data hash size
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 IBM DB2 Universal Database documentation for upgrading UDB version 8 to version 9.
Verify that all the primary database requirements are met as described in “IBM DB2 Universal Database Requirements”.
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.
After the migration, reset the use_rssd configuration parameter to false:
ra_config use_rssd, false
In the Replication Agent 15.1 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 8 to UDB 9 at the same time, you need to migrate Replication
Agent 15.1 only once.
