Need advice on preparation work before upgrading to IDS 15.0.0.1
Posted in 2025
ke chen asked what to prepare before upgrading from 14.10 to 15.0.0.1. Art Kagel endorsed the list: settle IPA tables, take a full backup, recompile 4GL, test Genero, ODBC and rowid, and do performance testing. Sebastien Flaesch said Genero 6.00 adds a CSDK 15 driver. Milan Rafaj asked about fixpacks; 15.0.0.2 was reported available in Fix Central.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL
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: Check for outstanding IPA tables and settle them Arrage a full DB backup, in case require rollback to 14.10, after infrastructure version 1 is enabled. Recompile 4GL programs in newer environment (new CSDK15, etc) Check if Genero 3.20/5 can work properly with IDS 15+CSDK15+JDBC15. Test application on ODBC 15 driver Test rowid in IDS15 Thanks for your advice. ------------------------------ ke chen ------------------------------
Ke: Responses in line with your list: Check for outstanding IPA tables and settle them Yes Arrange a full DB backup, in case require rollback to 14.10, after infrastructure version 1 is enabled. Yes 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. Check if Genero 3.20/5 can work properly with IDS 15+CSDK15+JDBC15. Yes Test application on ODBC 15 driver Yes Test rowid in IDS15 Yes That done, now two important things: Have you done any performance and compatibility testing on a test machine before planning to more to v15.0? 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 ------------------------------
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 ------------------------------
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 ------------------------------
Thank you Seb, we look forward to genero v6 test version. ------------------------------ ke chen ------------------------------
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 ------------------------------
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 ------------------------------
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 ------------------------------
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)
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 ------------------------------
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)
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 ------------------------------