Question & Answer
Question
Using 64bit IBM Cognos on 64-bit Linux, attempting to connect to the DB2 datasource results in an error... QE-DEF-0285 The logon failed. QE-DEF-0325 The logon failed for the following reason: RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: testDataSourceConnection UDA-SQL-0569 Unable to load the driver manager library ( libdb2.so ). UDA-SQL-0571 The operating system returned an error message ( libdb2.so: cannot open shared object file: No such file or directory ). BME-EX-0144 Trace back: BmtPlayTransaction.cpp(738): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction BmtActionsHelper.cpp(466): QFException: CCL_RETHROW: BmtActionsHelper::DoAction QFSSession.cpp(630): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(628): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest() QFSSession.cpp(1380): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection() Source/QE_RsApi.cpp(2064): QFException: CCL_RETHROW: QE Source/QEI_ConnectionFault.cpp(807): QFException: CCL_THROW: QE
Cause
64bit DB2 client software was installed
Answer
64-bit IBM Cognos has 64-bit java components but the native query engine, BIBusTkServer, is a 32-bit application. Therefore, it is necessary to install and configure the 32-bit DB2 client for IBM Cognos.
Refer to the statements regarding support for 64-bit environments at the following location:
https://www-304.ibm.com/support/docview.wss?rs=3528&uid=swg27014782
Check the following environment variables.
LD_LIBRARY_PATH should includes the 32-bit DB2 client libraries.
PATH should contain the DB2 bin directory.
DB2DIR should point db2 install directory.
Also run a ldd on the libdb2.so to make sure all of it's dependancies are available. On 64bit RedHat installs there may be 32bit packages that aren't installed by default.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21461123