Informix

 View Only
  • 1.  Documentation - Upgrade from IDS 12 to 14 in primary/HDR/RSS configuration

    Posted Sun May 23, 2021 03:42 AM

    Hello,

     

    I looked for information about upgrading primary/hdr/rss from IDS12 to 14

    But I only found for IDS11

    https://www.ibm.com/support/pages/upgrading-high-availability-data-replication-hdr-pair

     

    Do I have to go through the same steps for 12 to 14?

     

    Also,

    Step 4:

    I could understand that it's necessary to do a L0 backup close to the upgrade, but why just after it and before connecting the HDR? If it doesn't work, I won't restore from the fresh upgrade but from the last L0 before the upgrade.

     

    Step 7:

    If I choose to not bring the primary to standard mode,

    so I don't need to do a physical restore, isn't it?

    Thanks



    ------------------------------
    Sh To
    ------------------------------

    #Informix


  • 2.  RE: Documentation - Upgrade from IDS 12 to 14 in primary/HDR/RSS configuration

    IBM Champion
    Posted Sun May 23, 2021 10:15 AM
    More or less, nothing has changed. A couple of comments and answers to your questions:
    • You can in v14.10 upgrade an hdr or rss secondary by a single minor version without a restore. Going from 12.10 to 14.10 requires that the secondaries be restored from the primary.
    • The page you cited leaves out the final step, running the onmode -d secondary on the secondary after the restore. (Do NOT bring the secondary to online status.)
    • Optionally you can use ifxclone to create the new upgraded secondary instead of a manual archive & restore.
    • You need the archive after the upgrade in order to restore to the secondary with the new version!
    • You should indeed take an archive before upgrading also in case the upgrade goes horribly wrong.


    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 3.  RE: Documentation - Upgrade from IDS 12 to 14 in primary/HDR/RSS configuration
    Best Answer

    IBM Champion
    Posted Sun May 23, 2021 10:29 AM
    Art, I need to politely disagree ;-)

    As long as you don't want to perform so called 'rolling upgrade' of your cluster, where one server always would remain up, you would not have to recreate your secondaries when upgrading from [11.50,] 11.70, 12.10 or a previous 14.10.  to  14.10.xC4W1 or newer.

    Conversion Support for HDR and RSS Secondary Server

    -> Migrating an offline cluster to a new major version and High-availability cluster migration

    BR,
     Andreas

    ------------------------------
    Andreas Legner
    ------------------------------



  • 4.  RE: Documentation - Upgrade from IDS 12 to 14 in primary/HDR/RSS configuration

    IBM Champion
    Posted Sun May 23, 2021 11:03 AM
    Agree with Andreas, the last 12 to 14 I did - a couple of months ago - shutdown everything, upgrade everything, start everything -  just works.  I did take down connection manager for the duration as well though.

    If you have enough servers in the cluster you can leave one un-upgraded for fail back. 

    Cheers
    Paul

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC





  • 5.  RE: Documentation - Upgrade from IDS 12 to 14 in primary/HDR/RSS configuration

    IBM Champion
    Posted Sun May 23, 2021 01:49 PM
    Thanks Andreas. I was thinking of the ruling upgrade feature. 

    Art

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 6.  RE: Documentation - Upgrade from IDS 12 to 14 in primary/HDR/RSS configuration

    Posted Mon May 24, 2021 03:35 AM
    Thank you all

    ------------------------------
    Sh To
    ------------------------------