When you are trying to test the connection to the DB2 database from Cognos configuration and you are getting this error message:
XQE-JDB-0004 A problem occurred finding the driver class “com.ibm.db2.jcc.DB2Driver”.
This error cause because the Cognos cannot find the DB2 drivers. Solution of this problem is simple. You have to copy files db2jcc.jar and db2jcc4.jar to <Install_Cognos>\v5dataserver\lib and <Install_Cognos>\webapps\p2pd\WEB-INF\lib.
After you copy these files you need to restart the Cognos server.
Still Have the problem.
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-0031 Unable to access the “testDataSourceConnection” database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.
UDA-SQL-0106 The function “{0}” is not supported.
BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(788): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(1163): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1161): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(2055): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2106): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(829): QFException: CCL_THROW: QE
Script Stack Trace
Action No=1 Action Name=TestDataSourceConnection
Currently we are on cognos 10.2.2 , and i have placed below let of drivers in \v5dataserver\lib and \webapps\p2pd\WEB-INF\lib. But still issue is occurring.
sqljdbc42.jar
ojdbc5.jar
sqljdbc4.jar
db2jcc.jar
db2jcc4.jar