IBM Support

Upgrading High-Availability Data Replication (HDR) Pair

Troubleshooting


Problem

Upgrading High-Availability Data Replication (HDR) Pair - Steps for upgrading the database servers in an HDR pair.

Resolving The Problem


To upgrade High-Availability Data Replication (HDR) database server pair, you need to do the following steps:

    1. Switch the primary database server to standard mode by running the following command:

      onmode -d standard


      Note: Switching the primary to standard mode is not necessary. But, doing that will bring the primary online faster after the upgrade, because it will not try to connect to the secondary database server.

    2. Shutdown both database servers by running the following command:

      onmode -ky

    3. Upgrade the primary database server.

    Refer to the IBM Informix Migration Guide Unix, Linux and Windows for more details.


    4. Take a level 0 archive for the primary database server by using one of the following archive methods:

      ontape -s -L 0  OR  onbar -b -L 0

    5. Set the type of the primary database server to primary and indicate the associated secondary database server using the following onmode command:

      onmode -d primary sec_name

      sec_name
        The name of the secondary database server.

    6. Upgrade the secondary database server.


    7. Bring the secondary database server online using physical restore by using on of the following commands:

      ontape -p OR onbar -r -p

Note: It is recommended to upgrade the engines after taking both of them offline as the engines and the OS versions of a HDR pair should be identical. However you can do OS level patch upgrades without taking the engines offline.


EXAMPLE

    The following table shows the steps to be done for upgrading the servers in a HDR pair where ServerA is primary and ServerB is secondary.

    ServerA
    ServerB
    1.  onmode -d standard2.  onmode -ky
    3.  onmode -ky
    4.  Upgrade
    5.  oninit
    6.  ontape -s
    7.  onmode -d primary ServerB


    8.  Upgrade
    9.  ontape -p

[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF002","label":"AIX"},{"code":"PF025","label":"Platform Independent"},{"code":"PF008","label":"DYNIX\/ptx"},{"code":"PF010","label":"HP-UX"},{"code":"PF015","label":"IRIX"},{"code":"PF016","label":"Linux"},{"code":"PF026","label":"Reliant UNIX"},{"code":"PF027","label":"Solaris"}],"Version":"11.1;11.5;11.70","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
16 June 2018

UID

swg21110352