Informix

 View Only
Expand all | Collapse all

Are there many customers using Informix version 14.10?

  • 1.  Are there many customers using Informix version 14.10?

    Posted Thu December 12, 2019 08:46 AM
    Hi All,

    My customers using Informix version 11.70 are considering upgrading Informix next year for reasons such as end of support. Customers commonly believe that Informix version 14.10 will be unstable only after a year of release. So customers want to upgrade to version 12.10. Besides, there are no customers using Informix version 14.10 in Korea as far as I know.

    I think using version 14.10 rather than version 12.10 will provide better support for patching and case open from IBM and HCL Technologies.

    Are there many customer cases using 14.10 except for Korea?
    If so, it would be easy to persuade the customer to upgrade to version 14.10.
    Or how can I convince my customers to upgrade to version 14.10 if they believe that version 12.10 will be more stable?

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------

    #Informix


  • 2.  RE: Are there many customers using Informix version 14.10?

    IBM Champion
    Posted Thu December 12, 2019 09:15 AM
    SangGyu Jeong:

    Version 14.10.xC3 which was released last week contains, as far as I know, all known critical bug fixes and is the first stable release of v14.10. I do recommend to my clients that they upgrade to v14.10 sometime this year. At this point I do not have any active production users of v14.10.

    There are many advantages to using v14.10 over v12.10. Here are some highlights:
    • RSS and HDR secondary latency vastly improved resulting in a 50% or better reduction in latency and a reduction in overhead to the primary.
    • The code improvements for secondary latency also improved crash recovery making recovery after a crash more than twice as fast.
    • Performance improvements in many queries and transactions of about 10%.
    • Storage optimization (aka on disk compression) is included in Enterprise Edition v14.10 (was an extra cost option in v11 & v12).
    • Encryption At Rest (EAR) - was not available in v11 or v12. In v14.10.FC2 and later you can even use a remote key store like Amazon's to store encryption keys.
    • Improved support for backup-to-the-cloud using online cloud storage services.

    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: Are there many customers using Informix version 14.10?

    Posted Thu December 12, 2019 09:27 AM
    Thanks Art,

    Customers are afraid that they will be test cases because no other customer has upgraded Informix to version 14.10 yet.
    That's why I think customers are considering upgrading to 12.10 version.

    Anyway, I need to convince the customer to explain and upgrade the 14.10 enhancements.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 4.  RE: Are there many customers using Informix version 14.10?
    Best Answer

    Posted Thu December 12, 2019 09:52 AM

    This is one of the most annoying discussions we can have :)

    I believe I already stated my perspective here (or other forums before), but here goes again...

    First, let me state I fully understand your situation, and even customers concerns, but I do believe it misses some points which are important. Let's settle a few things first:

    1- ANY upgrade is a lot of work to be done properly (essentially due to the necessary tests, not because of the technical upgrade itself)
    2- ANY upgrade is a risk. In today's environment, where in general people are heavily overloaded with work, and resources are low, we all tend to favor the idea that "if it works, leave it"
    3- ALL versions have bugs! This may not look well on the mouth of an IT supplier employee, but facts are facts, and whoever wants to oppose to this idea, I suggest them to pick up the "next version" fixlist. Doesn't matter which vendor, product, or version we're talking about
    4- OCCASIONALLY there is a very nasty version coming out. It may be the FC1, or the FC7 (the older guys may recall 10.00.FC7...)
    5- What is a stable version for a customer can be an awful version for another. If you happen to hit a nasty bug that "only" happens on your environment, it will turn a wonderful version into a nasty one

    So... What I mean is that you don't really know how good is a version until you test it... within your environment and with your code. And the work involved in testing 12.10.FC13 on a customer environment is basically the same to test 14.10.FC3. And the advantages are huge in favor of 14.10 specially if you also consider the lifetime it has, compared with 12.10...

    I understand the fear of being the first..., but I don't understand the "confort" of being among the last ones. And if you decide to move to 14.10.xCn ("n" being a confortable number) and then you have the bad luck of 14.10.xCn being a "nasty one"?

    What customers should be concerned with, is to improve their ability to test their code in their conditions, as soon as possible, with as little work as possible. Improve their ability to rapidly provide test environments (cloud, private cloud, docker, VMs, Data Virtualization, etc., etc.) and to have the ability to test their applications and ecosystem in a more automated way... This is really where the value is nowadays...

    If they manage to do this, they will know when the time is right...

    Having said this, I can understand no one will want to jump into production with *FC1... But they should integrate *FC1 in the process above.
    Besides, how many of those customers monitor the latest fixpacks's fixlist? Are they aware of the nasty bugs that have been found in the versions above their current version, and that could byte them at any time? Do they evaluate the risk of those bugs vs the work to upgrade?...

    New versions should be put to the tests as soon as they're available... that and the monitoring of fixes and new features should dictate when to upgrade, and to which version.
    All the rest are just opinions, common sense, and ghosts... Not the things that should matter for this sort of decisions, when your software is important for your business.

    Regards.



    ------------------------------
    FERNANDO NUNES
    ------------------------------



  • 5.  RE: Are there many customers using Informix version 14.10?

    Posted Thu December 12, 2019 10:39 AM
    Thank you for your long answer. Fernando.
    As an Informix maintenance service engineer, I would like to recommend the most recent version upgrade, but I want to be as considerate of my customers as possible.
    With your advice, I will explain to my clients.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 6.  RE: Are there many customers using Informix version 14.10?

    IBM Champion
    Posted Thu December 12, 2019 10:49 AM
    I have been getting reports from others. Many upgrades to v14.10 in production, just not my customers yet, with few problems. One user reports only one of 10 upgraded servers ran into a problem that was worked around.

    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.








  • 7.  RE: Are there many customers using Informix version 14.10?

    Posted Thu December 12, 2019 11:39 AM
    Edited by System Fri January 20, 2023 04:11 PM
    Thank you for your additional answers and sharing reports.
    Of course, there are probably more customers using Informix in the US than South Korea. ;)

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 8.  RE: Are there many customers using Informix version 14.10?

    IBM Champion
    Posted Thu December 12, 2019 09:50 AM
    The customers are idiots then :-) I have live systems on FC1 and FC2 without any issues, they are not hitting the bugs that exist. Currently moving another customer from 11.7 to FC3 - planned go live in Q2

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





  • 9.  RE: Are there many customers using Informix version 14.10?

    Posted Thu December 12, 2019 10:23 AM
    Ha ha I agree too. :)
    I want to actively upgrade Informix but I try to persuade my clients gently.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 10.  RE: Are there many customers using Informix version 14.10?

    IBM Champion
    Posted Thu December 12, 2019 10:35 AM
    Only a bug you see it :-) I have one customer on 9.40.TC1 running on NT4 - probably the most stable system I look after

    Cheers
    Paul

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





  • 11.  RE: Are there many customers using Informix version 14.10?

    Posted Thu December 12, 2019 10:59 AM
    Wow, there are quite a few systems that work well without upgrading everywhere.
    I don't have to brag, but I think 7.31 is the lowest among my customers.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 12.  RE: Are there many customers using Informix version 14.10?

    IBM Champion
    Posted Thu December 12, 2019 04:34 PM
    Hi,

    I had two customers upgrade their production systems after taking our Informix DBA Course last years. 14.10.FC2 is stable and a FC3 was just released.

    Regards - Lester

    > Hi All,
    >
    > My customers using Informix version 11.70 are considering upgrading Informix next year for reasons such as end of support. Customers commonly believe that Informix version 14.10 will be unstable only after a year of release. So customers want to upgrade to version 12.10. Besides, there are no customers using Informix version 14.10 in Korea as far as I know.
    >
    > I think using version 14.10 rather than version 12.10 will provide better support for patching and case open from IBM and HCL Technologies.
    >
    > Are there many customer cases using 14.10 except for Korea?
    > If so, it would be easy to persuade the customer to upgrade to version 14.10.
    > Or how can I convince my customers to upgrade to version 14.10 if they believe that version 12.10 will be more stable?
    >
    > ------------------------------
    > SangGyu Jeong
    > Software Engineer
    > Infrasoft
    > Seoul Korea, Republic of
    > ------------------------------

    --
    ______________________________________________________________________
    Lester Knutsen lester@advancedatatools.com
    Advanced DataTools Corporation Voice: 703-256-0267 x102
    Visit our Web page: http://www.advancedatatools.com





  • 13.  RE: Are there many customers using Informix version 14.10?

    IBM Champion
    Posted Thu December 12, 2019 04:41 PM

    In my test today, FC2 to FC3 upgrade crashes the engine with an issue with sysadmin upgrade (-691/-111), but the engine does restart OK with FC3 at the next attempt. At the moment we are just editing the SQL file prior to the first FC3 start.

     

    The other irritant is you have to re-install the license keys, i.e.  FC3 reverted back to Dev not the  "Advanced Whatever It Is Called This Week" version that FC2 was running

     

    Cheers

    Paul

     






  • 14.  RE: Are there many customers using Informix version 14.10?

    Posted Thu December 12, 2019 04:48 PM

    The "edition", or whatever it's called this week :) is a property of the INFORMIXDIR... Not the instance.

    So, whenever you install one fixpack you need the "key" in the same installation folder.

    Did you uncompress the FC3 "key" to the installation folder, prior to installing FC3? If not, it explains the situation. In practice what you did was a change of edition within a fixpack upgrade. Something that the guys in the development lab worked hard to achieve :)
    The other problem deserves a ticket (in case you didn't open it) but sounds familiar to what a customer mentioned... But that one should have been fixed in FC3...

    Regards.



    ------------------------------
    FERNANDO NUNES
    ------------------------------



  • 15.  RE: Are there many customers using Informix version 14.10?

    IBM Champion
    Posted Thu December 12, 2019 04:52 PM

    Cos this is a dev/uat system then I just dumped FC3 on top of FC2 – not best practice I know but ....  I did nothing with the FC3 key, it will just have to be an additional step in the deployment

     

     

    Cheers

    Paul

     






  • 16.  RE: Are there many customers using Informix version 14.10?

    Posted Thu December 12, 2019 07:36 PM
    Hi Lester, Thank you for your information.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 17.  RE: Are there many customers using Informix version 14.10?

    Posted Fri December 13, 2019 02:58 AM
    Hi SangGyu Jeong
    I fully understand your concerns upgrading to 14.10.
    We did this upgrade to 14.10FC2 and were hit by APAR IT 30427 which nearly froze our production.
    We had a special build running the fix for this APAR.
    This special build was running stable for a couple of weeks and we upgraded to 14.10FC3 now which fixes this bug.
    Right now i feel comfortable running this release, no problems occurred.
    Generally speaking I would never again migrate to an FC1 or even FC2 release !!

    Regards
    Rainer








    ------------------------------
    Rainer von Bongartz
    ------------------------------



  • 18.  RE: Are there many customers using Informix version 14.10?

    Posted Fri December 13, 2019 03:20 AM
    Hi Rainer,
    Thank you for sharing your case.
    From version 11.10 to version 12.10, I had a lot of troubles like building a customer service with fix pack, FC1..FC2..FC3.
    That's why not only me but also customers are vaguely afraid of the early(?) Informix version.
    From the stories of those who left here, FC3 seems to be stable enough for use in production systems.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 19.  RE: Are there many customers using Informix version 14.10?

    Posted Fri December 13, 2019 05:04 AM
    Hi,

    There was an invitation-only 14.10 beta programme before FC1 came out and we took the opportunity to run our full application workload through a test system and did find a few significant bugs, one of which was a stuck virtual processor. Our system monitoring is decent so we can detect issues which we might otherwise miss. Everything we reported was fixed in FC1 or FC2. I am not sure if there was a beta programme with previous major releases but this combined with HCL's own testing improvements I have learnt about gives me more confidence in software quality.

    An interesting question you raise is about support. I imagine you are finding there is a reluctance to do bug fixes in 11.70 if the fix cannot be backported straightforwardly from 12.10 or 14.10. I don't think we are there yet with version 12.10. In any case I understand the differences between the latest 12.10 releases and 14.10 are less significant than between the latest 11.70 and 12.10.

    I strongly agree with Fernando's point 1 that there is essentially no difference when upgrading in terms of the testing required whether going to the next fix pack or jumping two major versions. However if your testing capability is limited, playing safe and going with where the majority of users are and implementing 12.10.xC13 might not be a bad move. Of course this has no guarantees either but there will still be plenty of new features to use.

    Ben.

    ------------------------------
    Benjamin Thompson
    ------------------------------



  • 20.  RE: Are there many customers using Informix version 14.10?

    Posted Fri December 13, 2019 08:11 AM
    Hi. Ben.
    Thank you for sharing your beta program experience. Interesting. And as you mentioned, I'm concerned about backport in support. In fact, it's been a while since 12.10 was released, and I wonder how long additional fix packs will be supported. The fix pack is released until xC13! Even that may not be the end.

    I would like to advise my clients to use the new version whenever possible. But as an engineer for an IBM business partner, I am in a position that I cannot strongly advise my clients. In addition, IBM Korea and my company do not intend to actively market Informix. (This is a story that is too far from the original topic.) In Korea, the market share or awareness of Informix is ​​very low, and there are few new Informix purchases. So my company probably only wants to keep its share as much as possible.

    It is such a sad situation that I am not able to actively advise customers to upgrade. Perhaps without issues like end of support, customers would continue to use Informix without upgrading.

    In Korea, changes in the system environment of customers are also quite conservative.
    Customers insist on only AIX and slower OS upgrades. (Most use AIX 7.1 and even 5.3!)
    That is one of the things that makes upgrading difficult.

    My customer who was using Informix 12.10.FC12W1 version had service failure due to APAR IT27997 defect on March 7, 2019. This was a significant issue where the instance would not restart after a system crash. So I asked IBM to make a special build for that version of Informix.

    At a similar time, Informix version 14.10.xC1 was officially released. APAR IT27997 was not fixed in version 14.10.FC1 because it was similar to the time when I requested to build special build.
    That experience also made it difficult for me to easily advise customers to upgrade to version 14.10.

    I do not overlook the emphasis of everyone who wrote earlier. But I love Informix as an engineer who has experienced Informix for over 10 years. So I want to get my customers to use the great features of Informix as much as possible.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 21.  RE: Are there many customers using Informix version 14.10?

    Posted Fri December 13, 2019 10:54 AM
    IT27997 looks like a nasty one to hit and does seem to rely on a particular sequence of table alters which is probably why you encountered it when others didn't. It seems your system state meant suffering from this defect was inevitable following an upgrade unless another customer found it first. Hopefully you are stable on your special build.

    I believe there will be a 12.10.xC14 at least but yes, the first release of 12.10 was back in 2013.

    With a bug as serious as the one you have cited, I would expect your business case (system down) would be strong enough to get a fix on any supported version.

    Ben.

    ------------------------------
    Benjamin Thompson
    ------------------------------



  • 22.  RE: Are there many customers using Informix version 14.10?

    Posted Fri December 13, 2019 11:35 AM
    Since applying special build 12.10.FC12W1X5WE my client system is very stable.
    For reference, IT27997 has been fixed in 14.10.FC2.

    According to APAR IT27997 description, it happened when the varchar size was reduced, and I didn't worry about that as unusual, but for my customers, it seems to be unexpectedly caught in such a case.
    At the time, I was pretty embarrassed by an unexpected system error. ;)

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 23.  RE: Are there many customers using Informix version 14.10?

    IBM Champion
    Posted Fri December 13, 2019 10:29 AM
    Hi

    Yes we have customers that we migrated to 14.10.FC2 and they also use IWA

    Everything runs fine.

    --
    Cordialement, Regards,

    Khaled Bentebal
    Directeur G??n??ral - ConsultiX
    T??l: 33 (0) 1 39 12 18 00
    Fax: 33 (0) 1 39 12 18 18
    Mobile: 33 (0) 6 07 78 41 97
    Email: khaled.bentebal@consult-ix.fr
    Site Web: www.consult-ix.fr




  • 24.  RE: Are there many customers using Informix version 14.10?

    Posted Fri December 13, 2019 10:44 AM
    Thanks for your reply, Khaled.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------