I've been running Db2 11.5 on an Ubuntu 22.10 box for quite some time, teaching myself Python and what-not.

I've just upgraded to Ubuntu 24.04, and although the OS itself isn't broken, practically every Python program I have written is. NOT ONE of the external (think "pip install...") libraries I need have worked, and the only way I have managed to install them successfully is to "pip install <package name> --break-system-packages".

Also, my personal IBM Db2 instance has broken - it won't even start: 

db2start: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory 

I installed libaio, using sudo apt-get install libaio1t64 libaio-dev, but nothing has changed. Db2 still won't come up.

Any ideas?

------------------------------
Marcus Davage CEng CITP MBCS BSc
Lead Product Developer, IBM Champion
BMC Software Ltd
------------------------------

Original Message:
Sent: 10/3/2024 6:20:00 AM
From: Philip Nelson
Subject: RE: Ubuntu 24.04 breaks all the things...

For the libaio problem you need to create a logical link from the new shared library back to the original name.

The other thing you will need to do is create links for the 4 libaws libraries from the 22.04 subdirectory back into the main lib directory.

That should solve your instance issues.  For your Python problems I can't help. 

At the present date, the Db2 v11.5 fixpacks that are available do not support (in the IBM sense of that term) the 24.04 ubuntu as yet.

However , it is only a matter of time until IBM releases a version to support 24.04 .

Regardless, you can "force it"  in the meantime (your mileage might vary), please check out this thread:

https://community.ibm.com/community/user/datamanagement/discussion/db2-on-linux-ubuntu-2404-lts-noble

After you get your Db2-instance running on 24.04 consider opening a different question (possibly on a different forum)  for your python trouble - because we cannot tell which version(s) of python you are using, and which interface to Db2 from python that you are using (e.g. is it ibm_db, or ibm_db_sa, or ibm_db_dbi,  or pyodbc ...) or which version(s) of python you are trying. If your interface uses clidriver , you should test clidriver on its own with your Db2-instance before involving python (as there may also be dependencies there, which might need workarounds that are unrelated to python per se).

There are separate forums (i.e. not on this site) for supporting python ibm_db, ibm_db_sa, ibm_db_dbi (all on github), or pyodbc etc. So choose the right forum.

------------------------------
Mike O'Reilly
------------------------------

Original Message:
Sent: 10/3/2024 9:55:00 AM
From: Mike O'Reilly
Subject: RE: Ubuntu 24.04 breaks all the things...

At the present date, the Db2 v11.5 fixpacks that are available do not support (in the IBM sense of that term) the 24.04 ubuntu as yet.

However , it is only a matter of time until IBM releases a version to support 24.04 .

Regardless, you can "force it"  in the meantime (your mileage might vary), please check out this thread:

https://community.ibm.com/community/user/datamanagement/discussion/db2-on-linux-ubuntu-2404-lts-noble

After you get your Db2-instance running on 24.04 consider opening a different question (possibly on a different forum)  for your python trouble - because we cannot tell which version(s) of python you are using, and which interface to Db2 from python that you are using (e.g. is it ibm_db, or ibm_db_sa, or ibm_db_dbi,  or pyodbc ...) or which version(s) of python you are trying. If your interface uses clidriver , you should test clidriver on its own with your Db2-instance before involving python (as there may also be dependencies there, which might need workarounds that are unrelated to python per se).

There are separate forums (i.e. not on this site) for supporting python ibm_db, ibm_db_sa, ibm_db_dbi (all on github), or pyodbc etc. So choose the right forum.

------------------------------
Mike O'Reilly
------------------------------

Unless you're using a VENV, you'll always have python problems with the upgrades.

------------------------------
José Pina Coelho
IT Specialist at Kyndryl
------------------------------