Informix

 View Only
  • 1.  14.10.FC7 Upgrade Issues/Warning

    IBM Champion
    Posted Tue November 23, 2021 03:50 PM

    All:

    Just completed some development environment upgrades to 14.10.FC7 (from FC6) and hit on a couple of issues you should be aware of.

    First, as noted in other threads, the MIRROR parameter has been deprecated and the engine setting is now always on. So if you weren't previously using it and had left the MIRRORPATH to a default setting, you need to clear that field out or it's going to barf.

    Second, we've got some microservice type processes that connect to our databases pretty aggressively, with fairly rapid retries. On two different instances, these processes constantly trying to connect somehow munged the SMI rebuild that happens as part of the upgrade process. This caused the engine to get stuck in single-user mode and the sysmaster database to be inaccessible. The workaround (for me) was to comment out DBSERVERALIAS and edit sqlhosts to change the port for DBSERVERNAME to an unpublished one before running the upgrade. You could also put a firewall block on the main port. Once I did this, the upgrade completed quickly and without incident.



    ------------------------------
    TOM GIRSCH
    ------------------------------

    #Informix


  • 2.  RE: 14.10.FC7 Upgrade Issues/Warning

    IBM Champion
    Posted Tue November 23, 2021 04:36 PM
    Thanks for the heads up Tom!

    Art

    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.








  • 3.  RE: 14.10.FC7 Upgrade Issues/Warning

    Posted Wed November 24, 2021 08:46 AM
    Hi there,

    thanks for the feedback - we´re planning to upgrade from FC3 to FC7 directly - do you think its better to do a step in between? FC3 > 6 > 7 ?

    ------------------------------
    Marc Demhartner
    ------------------------------



  • 4.  RE: 14.10.FC7 Upgrade Issues/Warning

    IBM Champion
    Posted Wed November 24, 2021 08:50 AM
    Go direct - unless you are using ER I can't think of any additional issues

    Cheers
    Paul

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





  • 5.  RE: 14.10.FC7 Upgrade Issues/Warning

    IBM Champion
    Posted Wed November 24, 2021 09:48 AM

    Agree with Paul. Direct should be fine.