If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Db2 connection issue QE-DEF-0285 on Cognos 8.4

Started by sismic, 31 May 2009 08:27:45 PM

Previous topic - Next topic

sismic

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.


kolonell

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.   

sismic

I have put the 32 bit version on my LIBPATH, any other ideas where should I look for?