Upgrading to Replication Server 15.2

This section describes how to upgrade to Replication Server 15.2 by upgrading your Replication Servers.

WARNING! Before upgrading to Replication Server 15.2 if your Replication Server is using an Adaptive Server RSSD with a version earlier than 12.5, you must upgrade this Adaptive Server to at least version 12.5. Otherwise, the upgrade process will fail.

If you are upgrading to Replication Server 15.2 on IBM AIX, Sun Solaris SPARC, or Sun Solaris 10 x86/x64, and using ERSSD, platforms must be 64-bit for the upgrade to function properly. For these operating systems, ERSSD can only be run on 64-bit machines.This is a restriction of the underlying SQL Anywhere database. To use Replication Server on 32-bit IBM AIX, Sun Solaris SPARC, or Sun Solaris 10 x86/x64, Sybase recommends that you use Adaptive Server for the RSSD. However, you cannot migrate data from an ERSSD to a RSSD.

StepsUpgrading to Replication Server 15.2 from an earlier version

  1. Back up your current installation.

    If you plan to install the Replication Server software in a directory other than an existing Sybase version directory, make sure that the interfaces file is accessible. See the Replication Server Installation Guide for instructions.

  2. Install the new Replication Server software. See Replication Server Installation Guide for instructions.

  3. Upgrade the RSSD for each Replication Server. See “Upgrading an RSSD”.

  4. Upgrade each user database that is managed by an upgraded Replication Server. See “Upgrading a user database in a replication system”.

WARNING! Do not stop the RepAgent, truncate the transaction log, increase the generation number, and so on, while upgrading an earlier version of Replication Server to version 15.2 to avoid malfunctioning of your replication system.

StepsUpgrading an RSSD

Complete these steps in the order shown in this section 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.

  1. Set the SYBASE environment variable to the directory where Replication Server 15.2 is installed.

  2. Log in as the “sybase” user and change to the $SYBASE directory.

  3. Verify that RSSD servers, Replication Servers, and RepAgents that you are upgrading are running.

  4. If the Replication Server uses Adaptive Server Enterprise for the RSSD, grant sa_role to the primary user at RSSD as follows:

    sp_role 'grant', sa_role, primary_user

    NoteThe 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.

  5. If the Replication Server uses embedded RSSD, edit the rs_name.cfg file, where rs_name is your Replication Server:

    1. Add the erssd_release_dir parameter to specify the location of the pre-upgrade SQL Anywhere. For example:

      erssd_release_dir=/work1/sybase/REP-15_1/ASA9
      
    2. Add the erssd_start_cmd parameter to specify the command to start ERSSD.

      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. 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=/work1/sybase/REP-15_1/ASA9/bin/dbspawn
      -f -q /work1/sybase/REP-15_1/ASA9/bin/dbsrv9
      -ct- -ti 0 -x "tcpip(PORT=11751;DOBROAD=NO;BLISTENER=NO"
      -o /work1/sybase/REP-15_1/samp_repserver/errorlog/SAMP_REPSERVER.out
      /work1/sybase/REP-15_1/samp_repserver/dbfile/SAMP_REPSERVER.db
      
  6. If the Replication Server uses embedded RSSD, and it is doing routing, edit the rs_name.cfg file, where rs_name is your Replication Server:

    1. Add the erssd_ra_release_dir parameter to specify the location of the pre-upgrade SQL Anywhere. For example:

      erssd_ra_release_dir=/work1/sybase/REP-15_1/ASA9
      
    2. 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=/work1/sybase/REP-15_1/ASA9/bin/dbltm
      -ud -S SAMP_RS_ERSSD_ra
      -C /work1/sybase/REP-15_1/samp_repserver/SAMP_RS_ERSSD_ra.cfg
      -ot /work1/sybase/REP-15_1/samp_repserver/SAMP_RS_ERSSD_ra.out
      -I /work1/sybase/interfaces
      
  7. Start rs_init:

    $SYBASE/$SYBASE_REP/install/rs_init
    

    You see the RS_INIT menu.

  8. Select Configure a Server Product. Choose Continue.

  9. Select Replication Server.

  10. Select Upgrade an Existing Replication Server.

  11. Complete the Upgrade Existing Replication Server screen 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 RS 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. rs_init displays the following message:

      Execute the Replication Server tasks now?
      
  12. 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, rs_init displays these messages:

    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:

  13. 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.

  14. Restart the 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 put back their old values before downgrading. Otherwise, the Replication Server may not start or may behave incorrectly. Replication Server 15.2 upgrade process prints all the current configuration option values in rs_config to rs_init log, so that you can restore their former settings before downgrading.

For instructions on downgrading an RSSD to an earlier version, see “Downgrading Replication Server to an earlier version”.