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

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

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

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

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

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

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

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

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.

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

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

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.

I discovered this problem this week, when I upgraded. Merci beaucoup! C'est fait.

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.

Hello Marcus,

I am glad my post could help someone to save time :-)

I discovered this problem this week, when I upgraded. Merci beaucoup! C'est fait.

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.