Upgrading from Replication Agent for UDB 15.0

This section describes how to upgrade Replication Agent for UDB 15.0 (which supports only UDB 8) to 15.1.

For each existing Replication Agent for UDB instance, Sybase recommends that you back up the complete existing Replication Agent instance directory.
Install the Replication Agent 15.1 software as described in "Installing the Replication Agent software" in the Replication Agent 15.1 Installation Guide. Sybase recommends that you install Replication Agent 15.1 into the same SYBASE directory as the previous version of Replication Agent.
Create the 15.1 version of all valid existing Replication Agent instances.

This step creates new Replication Agent 15.1 instances for all valid existing instances of the previous version of Replication Agent, regardless of whether the existing instances are for Oracle, IBM DB2 Universal Database, or Microsoft SQL Server. To complete the upgrade for Microsoft SQL Server or Oracle instances, please see the appropriate section in this appendix. If you do not want to run a newly-created instance on this host, simply delete the new instance directory.
1. On UNIX, set the SYBASE environment variables by changing directory to the SYBASE directory in which Replication Agent 15.1 is installed and source the SYBASE script:
  - For C Shell: source SYBASE.csh
  - For Bourne or Korn shell: . SYBASE.sh
2. Change directory to the Replication Agent 15.1 bin directory:
  - On UNIX:
```
cd $SYBASE/RAX-15_1/bin
```
  - On Windows:
```
cd %SYBASE%\RAX-15_1\bin
```
3. Use the ra_admin utility to create new versions of all valid existing instances:
```
ra_admin -u src_directory
```
  Here, src_directory is the full path name of the previous Replication Agent version's installation directory. This is the source directory. For example:
```
ra_admin -u d:\sybase\RAX-15_0
```
If necessary, set the RA_JAVA_DFLT_CHARSET environment variable in the Replication Agent 15.1 RUN_instance script to the name of the Java character set that is equivalent to the one being used at the primary database. For detailed information, see the Replication Agent 15.1 Administration Guide.
In the primary UDB, grant the previously existing pds_username user any additional required privileges.
Prevent users other than the previously existing Replication Agent pds_username user from any further access to the primary UDB database. This prevents any loss of replicated data.
Log in to the previously existing Replication Agent instance, verify that it is in Replicating state and allow replication to finish. To verify that replication has completed:
1. 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
2. When all of these values are zero, note the Last QID Sent from the last set of statistics
3. Issue the ra_locator update command so that Replication Agent retrieves the truncation point from Replication Server.
4. 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.
5. Quiesce the Replication Agent instance by issuing the quiesce command.
6. Shut down the Replication instance by issuing the shutdown command.
Start and log in to the Replication Agent 15.1 instance, and migrate the Replication Agent's metadata by issuing the ra_migrate command.
In the Replication Agent 15.1 instance, resume replication by issuing the resume command.
Allow all users to access the primary UDB database.