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:
Sent: Mon June 03, 2024 11:29 AM
From: Stein Jensrud
Subject: Db2 on Linux Ubuntu 24.04 LTS (noble)
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:
Sent: Fri May 31, 2024 04:19 AM
From: Yves-Antoine Emmanuelli
Subject: Db2 on Linux Ubuntu 24.04 LTS (noble)
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
------------------------------