Informix

 View Only

  • 1.  Upgrade from 12.10.FC12 to 12.10.FC14

    IBM Champion
    Posted Wed July 22, 2020 03:14 PM
    IDS 12.10.FC14
    Solaris 10  1/13 (current patch)

    We recently upgraded a test platform from 12.10.FC12 to 12.10.FC14.  From previous upgrades, I was expecting to observe messages in the online.log indicating successful upgrades of all the databases.  There were four user databases on the instance we upgraded.

    What I did observe was success messages for two of the databases (here is excerpt from online.log):

    07/20/20 16:11:17 INFO (migrate) Begin migrating database acoms
    07/20/20 16:11:17 INFO (migrate) Begin migrating database hudson_newname
    07/20/20 16:11:17 INFO (migrate) Finished migrating database hudson_newname
    07/20/20 16:11:18 INFO (migrate) Finished migrating database acoms
    07/20/20 16:20:46 Checkpoint Completed: duration was 0 seconds.

    What I did not observe was any mention of the other two user-created databases, nor any mention of conversion for sysadmin, onpload, sysha, sysmaster, sysuser, and sysutils.

    It appears to be operating normally.

    I wonder if, despite lack of messages in the online.log, maybe all the databases were successfully converted, anyway.

    Is there any way to know, for sure?

    A success on the test platform would mean that we upgrade Production, next.  But, I don't want to have any ticking time bombs that might blow up later.

    As I recall from past upgrades, I think there always were messages about converting every database.

    Thank you for any comments.

    DG

    ------------------------------
    David Grove
    ------------------------------

    #Informix


  • 2.  RE: Upgrade from 12.10.FC12 to 12.10.FC14

    IBM Champion
    Posted Wed July 22, 2020 05:59 PM
    I was concerned to not cause any risk to Production, so I opened a tech support cast to inquire about the appearance of migration messages for some databases, but not others.  Tech support told me that there really wasn't anything to convert, and after inspecting output from 'oncheck -cd' and 'oncheck -pe' said it's all good, and not to worry about it.

    So I guess we'll proceed with Production.

    I still wonder why some databases, but not others (as opposed to "all or none") required some migration processing.

    Well, we can't know everything, can we.

    "Nothing to see here, folks.  Move on."

    DG

    ------------------------------
    David Grove
    ------------------------------

    Original Message


  • 3.  RE: Upgrade from 12.10.FC12 to 12.10.FC14

    IBM Champion
    Posted Wed July 22, 2020 06:05 PM

    AFAIK it will only report if there was something to do

     

    Cheers

    Paul

     




    Original Message


  • 4.  RE: Upgrade from 12.10.FC12 to 12.10.FC14

    IBM Champion
    Posted Thu July 23, 2020 03:05 AM
    Hi David,

    12.10.FC12 to 12.10.FC14 is not a real migration, no "conversion from old version to new version" required and taking place, hence you're not seeing all the usual conversion and migration messages (and e.g. no 'onmode -b' would be required to go back to 12.10.FC12).

    Those "INFO (migrate)" messages would occur for databases having an auto-migratable datablade registered.

    HTH,
     Andreas

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

    Original Message


  • 5.  RE: Upgrade from 12.10.FC12 to 12.10.FC14

    IBM Champion
    Posted Thu July 23, 2020 12:21 PM
    Thank you.

    That information is very helpful.  I like knowing that those notifications were not arbitrary items, which depend on the phase of the moon.

    Also, good to know about not having to use 'onmode -b' to revert.

    Does that mean I could just change back to old Informix binaries, ONCONFIG, INFORMIXDIR, etc., and do an 'oninit' and 12.10.FC12 would run just fine?

    Regards,

    DG

    ------------------------------
    David Grove
    ------------------------------

    Original Message


  • 6.  RE: Upgrade from 12.10.FC12 to 12.10.FC14

    IBM Champion
    Posted Thu July 23, 2020 05:58 PM
    Regarding conversion/reversion  (which onmode -b refers to), yes, no reversion would be required and you could just switch binaries (i.e. INFORMIXDIR).

    Whether those blades that obviously did get adjusted somehow, would adjust back as easily I cannot tell.

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

    Original Message


  • 7.  RE: Upgrade from 12.10.FC12 to 12.10.FC14

    IBM Champion
    Posted Thu July 23, 2020 06:24 PM
    Thank you.

    Out of curiosity, I tried a little experiment.  I thought that perhaps, since the database page structure remains the same between FC12 and FC14, maybe I could restore a Level 0 backup made with FC12 to the newly upgraded FC14.  'ontape' objects, noting the difference in versions.  So, I cancelled out.  But, it did offer me the option to proceed anyway.  I declined.  But, this is a test platform, so I could go back and say "yes" and see what happens.  I'll try later.

    DG

    ------------------------------
    David Grove
    ------------------------------

    Original Message


  • 8.  RE: Upgrade from 12.10.FC12 to 12.10.FC14

    Posted Tue July 28, 2020 06:07 AM
    Hey David

    One for your bag of tricks if you didn't already know...
    $ echo "SELECT DBINFO('version','full') FROM systables WHERE tabid = 1;" | dbaccess <Database>

    (constant)

    IBM Informix Dynamic Server Version 12.10.FC13

    1 row(s) retrieved.


    ------------------------------
    Kirit Rana
    ------------------------------

    Original Message