Db2

 View Only

  • 1.  Db2 on Linux Ubuntu 24.04 LTS (noble)

    Posted Fri May 31, 2024 04:20 AM

    Hello,

    The library supporting asynchronous IO has changed, and the former package installing it, libaio does not exist in the subject new distribution.

    For DB2 server to function properly, the following has to be executed as root, after upgrading to the new distribution :

    cd /usr/lib/x86_64-linux-gnu

    ln -s libaio.so.1t64 libaio.so.1

    ls -l libaio*
    lrwxrwxrwx 1 root root    14 mai   26 12:20 libaio.so.1 -> libaio.so.1t64
    lrwxrwxrwx 1 root root    18 mars  31 09:43 libaio.so.1t64 -> libaio.so.1t64.0.2
    -rw-r--r-- 1 root root 14336 mars  31 09:43 libaio.so.1t64.0.2

    So when db2 searches for libaio.so.1, it is automatically directed to libaio.so.1t64 which in turn redirects to the current AIO library in operation for the distribution.

    I suppose this should be fixed in a future fix pack (to be confirmed).

    Hope this helps.

    Regards.



    ------------------------------
    Yves-Antoine Emmanuelli
    ------------------------------


  • 2.  RE: Db2 on Linux Ubuntu 24.04 LTS (noble)

    Posted Mon June 03, 2024 01:36 PM

    Hello,

    I tried to upgrade one of my Ubuntu 23.10 DB2  instances to 24.04. Ubuntu upgrade worked ok, but when I tried start db2 I got msg :

    $ db2start
    db2start: error while loading shared libraries: libaws-cpp-sdk-transfer.so: cannot open shared object file: No such file or directory
    $ db2 db2start
    SQL1652N  File I/O error occurred.

    I could not solve this situation and installed a new Ubuntu 24.04 instance in virtualbox and installed DB2 V11.5.9.

    I solved the libaio - challenge the same way as you. 

    Db2prereqcheck was normal, but db2 could not be started.

    I still get 

    $ db2start
    dtart:    b2s error while loading shared libraries: libaws-cpp-sdk-transfer.so: cannot open shared object file: No such file or directory

    $ db2 db2start
    SQL1652N  File I/O error occurred.

    libaws-cpp-sdk-transfer.so is located  in /opt/ibm/db2/V11.5/lib64/awssdk/UBUNTU/22.04/libaws-cpp-sdk-transfer.so     NBI no library for 24.04 as aspected.

    I have tried a symbolic link and copied libaws-cpp-sdk-transfer.so to current path etc, but still db2start: error while loading shared libraries: libaws-cpp-sdk-transfer.so: cannot open shared object file: No such file or directory

    Looks like Ubuntu 24.04 is not prepared for DB2.

      Can DB2 be started in your Ubuntu 24.04 environment?

    Regards,

    Stein Jensrud



    ------------------------------
    Stein Jensrud
    ------------------------------

    Original Message


  • 3.  RE: Db2 on Linux Ubuntu 24.04 LTS (noble)

    Posted Mon June 03, 2024 01:41 PM

    Indeed, Ubuntu 24.04 is not a supported OS for Db2 at this time.



    ------------------------------
    Matthew Emmerton
    ------------------------------

    Original Message


  • 4.  RE: Db2 on Linux Ubuntu 24.04 LTS (noble)

    Posted Mon June 03, 2024 02:58 PM

    Hello Stein,

    Yes my Db2 11.5.9 runs smoothly on Ubuntu 24.04 after solving the libaio issue.

    But my DB2 is installed locally on my ubuntu machine.

    Would it be the installation on Virtualbox that requires library libaws-cpp-sdk-transfer.so ?

    I would try the following :

    sudo su -

    cd /opt/ibm/db2/V11.5/lib64/awssdk/UBUNTU

    # ls -l 22.04
    total 10896
    -r-xr-xr-x 1 bin bin 4626704 nov.   8  2023 libaws-cpp-sdk-core.so
    -r-xr-xr-x 1 bin bin 1356312 nov.   8  2023 libaws-cpp-sdk-kinesis.so
    -r-xr-xr-x 1 bin bin 4871504 nov.   8  2023 libaws-cpp-sdk-s3.so
    -r-xr-xr-x 1 bin bin  290944 nov.   8  2023 libaws-cpp-sdk-transfer.so

    # cp -rp 22.04 24.04

    # ls -l 24.04
    total 10896
    -r-xr-xr-x 1 bin bin 4626704 nov.   8  2023 libaws-cpp-sdk-core.so
    -r-xr-xr-x 1 bin bin 1356312 nov.   8  2023 libaws-cpp-sdk-kinesis.so
    -r-xr-xr-x 1 bin bin 4871504 nov.   8  2023 libaws-cpp-sdk-s3.so
    -r-xr-xr-x 1 bin bin  290944 nov.   8  2023 libaws-cpp-sdk-transfer.so

    cd /opt/ibm/db2/V11.5/lib64

    # ls -l libaws*
    lrwxrwxrwx 1 root root 42 juin   3 20:39 libaws-cpp-sdk-core.so -> awssdk/UBUNTU/22.04/libaws-cpp-sdk-core.so
    lrwxrwxrwx 1 root root 45 mars  21 14:43 libaws-cpp-sdk-kinesis.so -> awssdk/UBUNTU/22.04/libaws-cpp-sdk-kinesis.so
    lrwxrwxrwx 1 root root 40 mars  21 14:43 libaws-cpp-sdk-s3.so -> awssdk/UBUNTU/22.04/libaws-cpp-sdk-s3.so
    lrwxrwxrwx 1 root root 46 mars  21 14:43 libaws-cpp-sdk-transfer.so -> awssdk/UBUNTU/22.04/libaws-cpp-sdk-transfer.so

    # ln -sf awssdk/UBUNTU/24.04/libaws-cpp-sdk-core.so libaws-cpp-sdk-core.so

    # ln -sf awssdk/UBUNTU/24.04/libaws-cpp-sdk-kinesis.so libaws-cpp-sdk-kinesis.so

    # ln -sf awssdk/UBUNTU/24.04/libaws-cpp-sdk-s3.so libaws-cpp-sdk-s3.so

    # ln -sf awssdk/UBUNTU/24.04/libaws-cpp-sdk-transfer.so libaws-cpp-sdk-transfer.so

    # ls -l libaws*
    lrwxrwxrwx 1 root root 42 juin   3 20:41 libaws-cpp-sdk-core.so -> awssdk/UBUNTU/24.04/libaws-cpp-sdk-core.so
    lrwxrwxrwx 1 root root 45 juin   3 20:42 libaws-cpp-sdk-kinesis.so -> awssdk/UBUNTU/24.04/libaws-cpp-sdk-kinesis.so
    lrwxrwxrwx 1 root root 40 juin   3 20:43 libaws-cpp-sdk-s3.so -> awssdk/UBUNTU/24.04/libaws-cpp-sdk-s3.so
    lrwxrwxrwx 1 root root 46 juin   3 20:44 libaws-cpp-sdk-transfer.so -> awssdk/UBUNTU/24.04/libaws-cpp-sdk-transfer.so

    I have run the above commands on my machine... and I have not broken anything :-)

    If this does not solve your issue, please provide us with the db2diag messages associated with the "error while loading shared libraries".

    Regards.



    ------------------------------
    Yves-Antoine Emmanuelli
    ------------------------------

    Original Message