Informix

 View Only
  • 1.  in place alters

    Posted Tue April 20, 2021 07:12 AM
    Hello

    do we need to fix inplace alters when upgrading from 11.70 to 14.10 with dbexport from source 11.7 server / dbimport on target 14.1 server ?

    Thanks



    ------------------------------
    John Smith
    ------------------------------

    #Informix


  • 2.  RE: in place alters

    IBM Champion
    Posted Tue April 20, 2021 07:58 AM
    No, The dbexport will export the latest schema version of the DDL and the data so that is what dbimport will import. Checkout myexport/myimport, my dbexport/dbimport replacement utilities. They are considerably faster than dbexport & dbimport.

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



  • 3.  RE: in place alters

    Posted Tue April 20, 2021 07:59 AM
    Thanks Art

    ------------------------------
    John Smith
    ------------------------------



  • 4.  RE: in place alters

    Posted Tue April 20, 2021 08:20 AM
    I saw that we need to fix in place alters when upgrading to 14.1, but i don't remember it for upgrading to 12.1, do we need to fix it as well before upgrading to  12.1 ?

    Thanks


    ------------------------------
    John Smith
    ------------------------------



  • 5.  RE: in place alters

    IBM Champion
    Posted Tue April 20, 2021 08:31 AM
    If you are doing an in place upgrade then that is the recommendation  

     My last 11.70 to 14.10 having outstanding in-place alters broke the onrestorept  reversion. However, it had zero impact on the actual upgrade itself.  The customer decided to rely on a restore if the upgrade failed rather than fix the in-place alters as the outstanding in-place alters where all on 1B+ row tables.

    As I have never reverted a production upgrade in my entire life I wasn't worried 

    Cheers
    Paul

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





  • 6.  RE: in place alters

    Posted Tue April 20, 2021 09:29 AM
    Thanks for your reply,

    OK
    that"s what i had understood, the inplace alters fixing is only needed when reverting from upgrade (onrestorept).
    so we can also do a full backup (L0) and restore it if something went wrong and then no need to inplace alters

    am i right ? :)





    ------------------------------
    John Smith
    ------------------------------



  • 7.  RE: in place alters

    IBM Champion
    Posted Tue April 20, 2021 09:35 AM

    Yep but we had a snapshot to revert from so close enough to instant.

     

    Cheers

    Paul

     






  • 8.  RE: in place alters

    IBM Champion
    Posted Tue April 20, 2021 09:47 AM
    You are right...but the biggest worry is if you need to revert days or weeks later (say you run into a bug or performance issues).  Restoring from the "old" backup will mean that recent changes will be lost and need to be reapplied somehow. 

    Saying that, just like Paul, I have not had to do this after a production upgrade...and I hope that I never have to!

    Taking a backup before the upgrade is best practice anyway.

    ------------------------------
    Mike Walker
    ------------------------------



  • 9.  RE: in place alters

    IBM Champion
    Posted Tue April 20, 2021 09:55 AM

    If you have to revert a production system then you haven't tested properly .... IMHO

     

    Cheers

    Paul

     






  • 10.  RE: in place alters

    IBM Champion
    Posted Tue April 20, 2021 08:16 AM
    Nope, you are flat filing the system so there is no need 

    Cheers
    Paul

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