Hi guys, I spent days of troubleshooting without any success to solve db2 connection issue.
We have 8.4 in 32 bit on AIX 64 bit. When I try to connect db through Cognos Content ,the error message are as follows:
RQP_DEF-0068 Unable to connect to at least one database during a multidatabase attache to 1 database(s) in : testDataSourceConnection
UDA-SQL-0569 Unable to load the driver manager library (libdb2.a(shr.0)).
USDA-SQL-0571 The operating systen returned an error message (Could not load module /usr/opt/db2_08_01/lib/libdb2.a(shr.0).
Could not load module /home/d..../sqllib/lib/libdb2.a(shr.0)
When I try to connect on shell, it works fine. I have reference this directory in LD_LIBRARY_PATH and LIBPATH.
When I install Cognos, I use the same unix account and it could connect to db2 database to create content store, but not sure why it seems does not work in Cognos connection.
Any suggestion when should I look?
Thanks in advance.
Check what the bitness (32 or 64 bit) that library is, using the file command (file /usr/opt/db2_08_01/lib/libdb2.a) and make sure you reference the 32bit libraries in your LIBPATH.
I have put the 32 bit version on my LIBPATH, any other ideas where should I look for?