Hi
I've setup a Cognos environment on SUSE 10/System z.
The installation is complete and the application is running fine.
The problem that I'm facing is that I'm unable to connect to DB2 database (where our data warehouse is located)
The connection fails giving the following error:
UDA-SQL-0571 The operating system returned an error message ( libdb2.so: wrong ELF class: ELFCLASS64 )
Apparently its a 32 bit version of the file thats required.
I copied the file libdb2.so from <db2 location>/sqllib/lib - although in the local installation there are two directories lib and lib64, I noticed that both point to the same location.
So essentially there is only one libdb2.so on the system and its a 64 bit version:
# file libdb2.so.1
libdb2.so.1: ELF 64-bit MSB shared object, IBM S/390, version 1 (SYSV), not stripped
------------------------------------------------------------------------------
Is there any work around for this? Can I obtain the 32 bit libdb2.so file from some other location and copy it to the cognos bin? (If yes how where can I get it?)
Would appreciate any support/solution for this.
The full error is:
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: wrong ELF class: ELFCLASS64 ).
BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(757): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(716): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(714): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1545): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2071): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE
Thanks & Best Regards
I have the same issue with cognos 10.2 on RedHat Linux. Any help is appreciated
Problem still exists in Cognos 10.2.1 FP4
RHEL 6.5
DB2 10.5