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: 

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

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.

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.

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

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.

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

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

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,

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

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

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

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.

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,

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

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

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

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.