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
Expand all | Collapse all

Need advice on preparation work before upgrading to IDS 15.0.0.1

  • 1.  Need advice on preparation work before upgrading to IDS 15.0.0.1

    Posted Wed August 13, 2025 08:42 PM

    Hi community,

    May I ask for your opinion and advice on preparations before upgrading IDS from 14.10 to 15.0.0.1? Thank you!

    So far, I've noted the followings are to be done prior to the upgrade:

    1. Check for outstanding IPA tables and settle them
    2. Arrage a full DB backup, in case require rollback to 14.10, after infrastructure version 1 is enabled.
    3. Recompile 4GL programs in newer environment (new CSDK15, etc)
    4. Check if Genero 3.20/5 can work properly with IDS 15+CSDK15+JDBC15.
    5. Test application on ODBC 15 driver
    6. Test rowid in IDS15

    Thanks for your advice.



    ------------------------------
    ke chen
    ------------------------------


  • 2.  RE: Need advice on preparation work before upgrading to IDS 15.0.0.1

    Posted Thu August 14, 2025 09:44 AM

    Ke: 

    Responses in line with your list:

    1. Check for outstanding IPA tables and settle them
      Yes
    2. Arrange a full DB backup, in case require rollback to 14.10, after infrastructure version 1 is enabled.
      Yes
    3. Recompile 4GL programs in newer environment (new CSDK15, etc)
      Is this Classic 4GL or Genero compiled code? If Classic, make sure that you have the latest updated version of the 4GL compiler that was released shortly after v15.0 was released.
    4. Check if Genero 3.20/5 can work properly with IDS 15+CSDK15+JDBC15.
      Yes
    5. Test application on ODBC 15 driver
      Yes
    6. Test rowid in IDS15
      Yes

    That done, now two important things:

    1. Have you done any performance and compatibility testing on a test machine before planning to more to v15.0? 
    2. I would recommend waiting for v15.0.0.1.2 release before moving to production because there are significant performance issues with 15.0.0.1 and 15.0.0.1.1 affecting even SMALL tables that I have identified and reported. Hopefully these will be mostly resolved in the next fixpack release coming soon.

    Art



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



  • 3.  RE: Need advice on preparation work before upgrading to IDS 15.0.0.1

    Posted Thu August 14, 2025 07:16 PM

    Thanks Art!

    Yes, we will arrange performance baseline/compatibility tests in a cloned DB environment.

     We probably would stay on 14.10.FC10W2 until a stable version 15 is released (tested 14.10.FC12W5 and reported couples of bugs). thanks again.



    ------------------------------
    ke chen
    ------------------------------



  • 4.  RE: Need advice on preparation work before upgrading to IDS 15.0.0.1

    Posted Fri August 15, 2025 05:06 AM

    Hello Ke,

    Regarding:

    4. Check if Genero 3.20/5 can work properly with IDS 15+CSDK15+JDBC15.

    Genero BDL <= 5.01 supports Informix CSDK versions up to 4.50 with the dbmifx_9 ODI driver, typically for Informix IDS 14 (or older).

    Starting with Genero BDL 6.00, we will have a second Informix driver for CSDK 15, named dbmifx_15, to be used to connect to an Informix 15 server.
    The new dbmifx_15 driver is linked dynamically with new CSDK 15 libs
    Ticker #: FGL-6282
    Genero 6.00 GA is planed for end of 2025, but we will deliver testing versions during the V6.00 Early Access Program starting end September.

    If you want to use an Informix 15 server with Genero <= 5.01, while it's not optimal, it is possible to connect to Infromix 15 with the dbmifx_9 driver, using CSDK 4.50.

    You should consider the platforms supported by Informix 15 + CSDK 15: this version is not available on all platforms supported by older Informix versions.

    https://www.ibm.com/support/pages/informix-client-software-development-kit-client-sdk-and-informix-connect-system-requirements

    Side note:
    Except if you do SQL with your Java code, using the Java interface of Genero, you do not need JDBC (15).
    But I doubt that you open 2 concurrent connections in the same program... 

    If you have more questions about Genero, contact your support channel for best assistance!

    BR,

    Seb



    ------------------------------
    Sebastien FLAESCH
    ------------------------------



  • 5.  RE: Need advice on preparation work before upgrading to IDS 15.0.0.1

    Posted Fri August 15, 2025 07:09 AM

    Thank you Seb, we look forward to genero v6 test version.



    ------------------------------
    ke chen
    ------------------------------



  • 6.  RE: Need advice on preparation work before upgrading to IDS 15.0.0.1

    Posted Fri August 15, 2025 10:16 AM

    Ke,

    Glad to read that you will test Genero V6.

    See also this discussion about CSDK / Server compatibility:

    https://community.ibm.com/community/user/discussion/informix-15-server-csdk-compatibility-matrix#bm2fb1e26d-1b0a-4b06-b7e5-de117d162ac4

    Seb



    ------------------------------
    Sebastien FLAESCH
    ------------------------------



  • 7.  RE: Need advice on preparation work before upgrading to IDS 15.0.0.1

    Posted Sun August 17, 2025 09:06 PM

    Thanks Sebatien.

    May I ask:

    Besides of the informix driver change in Genero V6, what are other changes if compare Genero V5 and V6?

    We have run lots of tests in V5 in last months, do we need to redo all the tests to check compatibility & performance on genero V6?



    ------------------------------
    ke chen
    ------------------------------



  • 8.  RE: Need advice on preparation work before upgrading to IDS 15.0.0.1

    Posted Mon August 18, 2025 02:42 AM

    Hello Ke,

    We put a lot of efforts to keep our products backward compatible.

    There is quite a bit shift between V3 and V4 because of the Universal Rendering display as unique option (no more native rendering)

    Upgrading from Genero V5 to V6 is a smaller jump.

    All changes and potential backward compatibility issues can be found in release notes of our products.

    For example, for V5.01:

    https://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_Migrate_to_501.html

    New features can be found here:

    https://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_nf.html

    Additional information for other Genero products can by found in dedicated manuals, for example for GBC:

    https://4js.com/online_documentation/fjs-gbc-manual-html/#gbc-topics/c_gbc_migrating.html

    https://4js.com/online_documentation/fjs-gas-manual-html/#gas-topics/c_gas_migrating.html

    Genero V6.00 new features and upgrade notes will be available when the Early Access Program starts.

    Seb



    ------------------------------
    Sebastien FLAESCH
    ------------------------------



  • 9.  RE: Need advice on preparation work before upgrading to IDS 15.0.0.1

    Posted Mon September 01, 2025 06:01 AM

    Hello Art,

     

    From where is it possible to get fixpaks 15.0.0.1.2+ fixpaks I do not see them in FixCentral (neither 15.0.0.1.1) only 15.0.0.1

     

    Thanks a lot

     

    Milan Rafaj

    Senior Lead, Infrastructure/Cloud Architecture

    Kyndryl Consult

    +420 737 264 248

    www.kyndryl.cz

     

    Planned absence/Plánovaná nepřítomnost: 22-26.9., 1-3.10.2025

     

    Kyndryl Česká republika, spol. s r. o.

    Sídlo: Praha 4, Chodov, V Parku 2308/8, PSČ: 148 00,

    IČ: 14890992

    Zapsaná v obchodním rejstříku, vedeném Městským soudem v Praze (oddíl C, vložka 339277)

    Registered address: Prague 4, Chodov, V Parku, 2308/8, Zip code: 148 00

    Company ID: 14890992

    Entered in the Commercial Register maintained by the Municipal Court in Prague (Part C, Entry 339277)

     






  • 10.  RE: Need advice on preparation work before upgrading to IDS 15.0.0.1

    Posted Mon September 01, 2025 07:28 AM

    Milan:

    The current release is 15.0.0.1 (there is a 15.0.0.1.1 fixpack, but it mostly fixes the installer on some platforms). The next fixpack will be 15.0.0.2 which is finished and in review and testing and should be released soon.

    Art



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



  • 11.  RE: Need advice on preparation work before upgrading to IDS 15.0.0.1

    Posted Mon September 01, 2025 07:49 AM

    Thank you Art.

     

    Milan Rafaj

    Senior Lead, Infrastructure/Cloud Architecture

    Kyndryl Consult

    +420 737 264 248

    www.kyndryl.cz

     

    Planned absence/Plánovaná nepřítomnost: 22-26.9., 1-3.10.2025

     

    Kyndryl Česká republika, spol. s r. o.

    Sídlo: Praha 4, Chodov, V Parku 2308/8, PSČ: 148 00,

    IČ: 14890992

    Zapsaná v obchodním rejstříku, vedeném Městským soudem v Praze (oddíl C, vložka 339277)

    Registered address: Prague 4, Chodov, V Parku, 2308/8, Zip code: 148 00

    Company ID: 14890992

    Entered in the Commercial Register maintained by the Municipal Court in Prague (Part C, Entry 339277)

     






  • 12.  RE: Need advice on preparation work before upgrading to IDS 15.0.0.1

    Posted Tue September 02, 2025 08:48 AM
    Hello, Milan
     
    You can find version 15.0.0.2 in the central fix, it is available dated August 28, 2025
    Greetings


    ------------------------------
    Arnulfo Martinez Ruiz
    ------------------------------