Q3): Is it posible to have this slides later ?
Ans): Below is the link to download slides:
https://community.ibm.com/community/user/hybriddatamanagement/viewdocument/upgrade-with-success-from-informix?CommunityKey=b5b60ace-5eb2-4444-a961-d9edb6f39bd8Q4): quetion might not belong to this sessions, last time I migrate from 11 to 12 , I run oncheck -cD and It long time on table SYSAMS around 4 houers.
Ans): sysams is the system catalog table to determine if additional access methods are there in your nvironment and you have registered them! Not really sure where it gets stuck. onstat's data should be required to analyze the issue. This should have deal with support team
Q5): what is the recomendation regarding chunks? cooked filer or raw device ?
Ans):Please refer below tech note:
https://www.ibm.com/support/pages/what-are-differences-between-using-raw-disk-vs-cooked-files-informix-chunk-files-unix-serverQ6): Using the ER, I guess there is no need for any oncheck ?
Ans:) Yes, if you are doing migration using ER, i would still suggest you to do that because it's a new system on a different hard disk. So corruption can occur anytime.
Q7): In case you migrate using HDR, you mean u can have a primary server which can be 11.70 and the secondary server 14.10 ? and when I go live with it is just to swich between them and in case of any problem, is it just to swich back?
Ans:) No. If you have Primary and HDR, and you are doing in-place upgrade, then you have to do version upgrade in the same window and then start your primary instance followed by HDR instance.
And incase you are migrating using fancy techniques like Rolling upgrade & cdr migrate server, they uses ER in the background which rill convert your HDR to ER. In this case you can have primary on 11.70 and there will no HDR. In-fact HDR will be converted to ER node which keeps on snooping data from primary and keep it up-to date with primary. Later when your primary is on 14.10, you can again configure your HDR.
Please refer the URL of cdr migrate server and rolling upgrade for more info. And make sure before you proceed to production with any of these techniques, you must have tried this on your STG/Test instances
Q8): what is the recomendation value for CONVERSION_GUARD ? 1 or 2?
Ans:) 1 = Enable a restore point as part of the upgrade process, and stop the upgrade if an error related to capturing restore point data occurs.
2 = Enable a restore point as part of the upgrade process, and continue the upgrade even if an error related to capturing restore point data occurs.
More to Come...……….
------------------------------
Gaurav Kumar
------------------------------
Original Message:
Sent: Tue July 28, 2020 12:40 AM
From: Gaurav Kumar
Subject: Upgrade with Success from Informix 11.70 to Informix 14.10
Few Questions which were raised during my webinar are (I will keep on adding to this thread)…
Q1): will 14.10 upgrade will reduce storage size compared with 11.70 ?
Ans): Probably not ... unless you use features like COMPRESSION.
Q2): In my case we have PRIM-SDS-HDR(DR), I'm planning to upgarde prim 1st and then move to other replication
Ans): When you are doing in-place upgrade, you have to upgrade your IDS version across cluster in the same downtime to the same version. It doesn't matter which server you choose first, because all were down when you are doing in-pace upgrade.
Reason for saying upgrade in the same downtime is, you can not have different version across cluster. So if your primary is upgraded to 14.10, then it's secondary's would also be on 14.10.
More to come....
------------------------------
Gaurav Kumar
Original Message:
Sent: Fri July 17, 2020 01:53 PM
From: Jessica Leitsch
Subject: Upgrade with Success from Informix 11.70 to Informix 14.10
Hello,
You can watch the full webinar recording here. The slides can be downloaded here. Please share your questions below.
------------------------------
Jessica Leitsch
IBM Community Manager
Original Message:
Sent: Tue June 09, 2020 02:16 PM
From: Jessica Leitsch
Subject: Upgrade with Success from Informix 11.70 to Informix 14.10
Are you running IBM Informix Dynamic Server (IDS) 11.70?
Join this session to help with your plans to migrate from Informix 11.70 to Informix 14.10 with ease. Please note that Informix 11.70 will reach End of Service (EOS) on September 30, 2020.
Upgrade with Success from Informix 11.70 to Informix 14.10 webinar is now available to watch on demand
here. Please post your questions below.
------------------------------
Jessica Leitsch
IBM Community Manager
------------------------------
#Informix