Upgrading a RSSD or an ERSSD

Complete the steps below in the order shown to upgrade an RSSD based on the information from the “Replication Server installation worksheet” for the Replication Server you are upgrading. Upgrading an RSSD may add new Replication Server system tables, add new rows or columns to existing tables, or install new stored procedures.

Upgrading an RSSD or an ERSSD

Set the SYBASE environment variable to the directory where Replication Server 15.5 is installed by running SYBASE.sh

Verify that RSSD and Replication Servers that you are upgrading are running.

If the Replication Server uses Adaptive Server for the RSSD, grant sa_role to the primary user at the RSSD:

sp_role 'grant', sa_role, primary_user

You can revoke the “sa” role after the upgrading by executing:

sp_role 'grant', sa_role, primary_user

The RSSD_primary_user in the .cfg file must have a replication role or “sa” role, not the sa user ID or the user that has been entered in the rs_init panel.

If the Replication Server uses an ERSSD, edit the rs_name.cfg file, where rs_name is your Replication Server:

Add the erssd_release_dir parameter to specify the location of the pre-upgrade SQL Anywhere. For example:
```
erssd_release_dir=/sybase/REP-15_1/ASA9
```

Add the erssd_start_cmd parameter to specify the command to start ERSSD.

You can find an example of the parameter in the Replication Server log file by searching for “ERSSD start command”. For example:

erssd_start_cmd=/sybase/REP-15_5/ASA11/bin/dbspawn
-f -q /sybase/REP-15_5/ASA11/bin/dbsrv11
-ct- -ti 0 -x "tcpip(PORT=11751;DOBROAD=NO;BLISTENER=NO)"
-o /sybase/REP-15_5/samp_repserver/errorlog/SAMP_REPSERVER.out
/sybase/REP-15_5/samp_repserver/dbfile/SAMP_REPSERVER.db

Obtain the name and location of the Replication Server you are upgrading, and the port number of the Replication Server RSSD, from the interfaces file.

If the Replication Server uses an ERSSD, and it is doing routing, edit the rs_name.cfg file, where rs_name is your Replication Server:

Add the erssd_ra_release_dir parameter to specify the location of the pre-upgrade SQL Anywhere. For example:
```
erssd_ra_release_dir=/sybase/REP-15_1/ASA9
```
Add the erssd_ra_start_cmd parameter to specify the command to start ERSSD.

Obtain the name of the ERSSD Replication Agent and the location of the interfaces file from the Replication Server log file by searching for “Starting embedded RSSD Replication Agent” and using the same command format from the next line: “Executing command:”. For example:
```
erssd_ra_start_cmd=/sybase/REP-15_5/ASA11/bin/dbltm
-ud -S SAMP_RS_ERSSD_ra
-C /sybase/REP-15_5/samp_repserver/SAMP_RS_ERSSD_ra.cfg
-ot /sybase/REP-15_5/samp_repserver/SAMP_RS_ERSSD_ra.out
-I /sybase/interfaces
```

Start rs_init:

$SYBASE/$SYBASE_REP/install/rs_init

You see the RS_INIT menu.

Select Configure a Server Product. Choose Continue.

Select Replication Server.

Select Upgrade an Existing Replication Server.

Complete the Upgrade Existing Replication Server window with the information from the “Replication Server installation worksheet” for the Replication Server you are upgrading.
1. Enter the name of the Replication Server with the RSSD you are upgrading.
2. Enter the login name for the Replication Server “sa” user. The default value is “sa.”
3. Enter the password for the “sa” user on the Replication Server.
4. Enter the path name of the Replication Server Configuration file.
5. Press Ctrl+A to save your changes. You see:
```
Execute the Replication Server tasks now?
```
Enter “y” to continue the RSSD upgrade.

rs_init displays informational messages as it loads the upgrade script into the RSSD. When the upgrade is complete, you see:
```
RSSD successfully upgraded from old_rel_no to
new_rel_no. Replication Server 'rs_name' can now be
restarted. Task to upgrade the RSSD succeeded.
Configuration completed successfully.
```
where:
- old_rel_no – is the Replication Server version from which you are upgrading.
- new_rel_no – is the new Replication Server version.
- rs_name – is the name of the Replication Server.
If you have more Replication Servers to upgrade, return to “Upgrading Replication Server” and repeat the procedure.
If you installed the new Replication Server software in a different directory from the earlier version, modify the runserver files for the Replication Servers so that they use the programs in the new version directory.
Restart Replication Server using the appropriate executables for the new version.

WARNING! Some Replication Server configuration options with newer versions may have a wider valid range. If you increase any of these configuration options after upgrading, you must reinstate the old values before downgrading. Otherwise, the Replication Server may not start or may behave incorrectly. The Replication Server upgrade process prints all the current configuration option values in rs_config to rs_init log, so that you can restore the former settings before downgrading. See “Downgrading Replication Server to an earlier version”.