Db2

 View Only
  • 1.  Ubuntu 24.04 breaks all the things...

    IBM Champion
    Posted Thu October 03, 2024 06:08 AM

    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
    ------------------------------


  • 2.  RE: Ubuntu 24.04 breaks all the things...

    IBM Champion
    Posted Thu October 03, 2024 06:20 AM
    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. 





  • 3.  RE: Ubuntu 24.04 breaks all the things...

    IBM Champion
    Posted Thu October 03, 2024 11:15 AM

    Thanks Phil! That worked.

     

    Regards,

    Marcus Davage CEng CITP MBCS

    Lead Product Developer
    Intelligent Z Optimization and Transformation
    BMC Software Ltd
    Direct +44 118 921 8517
    Mobile +44 7840 023 560
    Email marcus_davage@bmc.com

    MarcusDavage@bmcsoftware.onmicrosoft.com/bookings/">Book time to meet with me

    IBM Champion 2024 badge image. Issued by IBM

     






  • 4.  RE: Ubuntu 24.04 breaks all the things...

    Posted Thu October 03, 2024 09:55 AM

    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
    ------------------------------



  • 5.  RE: Ubuntu 24.04 breaks all the things...

    IBM Champion
    Posted Thu October 03, 2024 11:15 AM

    Thanks Mike. That link worked a treat.

     

    Regards,

    Marcus Davage CEng CITP MBCS

    Lead Product Developer
    Intelligent Z Optimization and Transformation
    BMC Software Ltd
    Direct +44 118 921 8517
    Mobile +44 7840 023 560
    Email marcus_davage@bmc.com

    MarcusDavage@bmcsoftware.onmicrosoft.com/bookings/">Book time to meet with me

    IBM Champion 2024 badge image. Issued by IBM

     






  • 6.  RE: Ubuntu 24.04 breaks all the things...

    IBM Champion
    Posted Mon October 07, 2024 05:06 AM

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



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