Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Things to do before upgrade - HDR/RSS

    Posted Thu April 22, 2021 05:44 AM
    Edited by System Admin Fri January 20, 2023 04:19 PM
    Hello

    As i can see here , there are a bunch of things to do or check before upgrade (IDS12 > 14).

    But do I have to do all this on all the servers ?

    For example, UDRs
    Do i have to recompile them also on the HDR and RSS ?

    (Also, if you have a link to UDR compile/recompile process, I'll be pleased)


    Also, verifying integrity of data pages

    https://youtu.be/xsylAz5U1sY?t=1328


    Thanks

    ------------------------------
    Sh To
    ------------------------------
    #Informix


  • 2.  RE: Things to do before upgrade - HDR/RSS

    Posted Thu April 22, 2021 06:51 AM
    This may be useful:

    https://www.oninitgroup.com/faq-items/informix-upgrades-and-oncheck

    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------

    Original Message


  • 3.  RE: Things to do before upgrade - HDR/RSS

    Posted Thu April 22, 2021 06:56 AM
    To answer your specific question, anything in file systems, such as recompiling C or Java UDRs, will need to be copied to HDR/RSS servers. Anything in the IDS instance can only be done on the primary, and may require rebuilding HDR/RSS instances from level 0 archives if not achieved via SQL, for example "oncheck". Others will correct me if I'm wrong!

    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------

    Original Message


  • 4.  RE: Things to do before upgrade - HDR/RSS

    Posted Thu April 22, 2021 07:34 AM
    It depends on the UDR, for instance any custom TS UDRs should be recompiled as TS is normally tightly coupled to the engine. But if you are using the regex, either IBM or Oninit version,  functions within your UDR then there is no need to recompile

    Cheers
    Paul

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



    Original Message


  • 5.  RE: Things to do before upgrade - HDR/RSS

    Posted Sun April 25, 2021 04:06 AM
    Hello,,

    And what about the those checks ?
    oncheck -***

    https://youtu.be/xsylAz5U1sY?t=1328

    Is it necessary to execute them on the HDR/RSS or primary is enough ?

    Thanks



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

    Original Message


Related Content