Data Source Connection Issue

[laxmanrao83]

Hi All,

In Data Source Connection i have given the data base details and when i am trying to test the data source connection geting below error

DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit.

Please find the screenshot for more information.

Please help me in this issue.
Thanks,
Laxman

[MFGF]

Ok. So it's a DB2 database? There are errors from both the native client test and the JDBC test - the native client test looks like it is saying "The login failed". Did you check the "password" checkbox before entering the password into the credentials field?

MF.

[laxmanrao83]

Hi
Thanks for your reply
i have given the correct credential for db2 database.

Thanks & Regards,
Laxman Rao

[MMcBride]

A quick google on the error sent me here:

http://www-01.ibm.com/support/docview.wss?uid=swg21636329

If that doesn't do it for you try:

http://www.ibm.com/developerworks/data/library/cognos/infrastructure/cognos_specific/page529.html

Specifically:

IBM DB2

Understanding How IBM Cognos 10 Connects to IBM DB2

For this data source, the IBM Cognos 10 Compatible Query Mode requires the installation of the IBM DB2 client software. The IBM Cognos 10 Dynamic Query Mode on the other hand only requires access to the IBM DB2 type 4 JDBC driver and its appropriate license file. The following table lists the type of IBM DB2 databases and the required license file name.


Table 2 License file names for the various IBM DB2 platforms
IBM DB2 Database License File Name
DB2 UDB for Linux, UNIX and Windows db2jcc_license_cu.jar
DB2 UDB for Linux, UNIX, Window, z/OS db2jcc_license_cisuz.jar

Configuring Connectivity to IBM DB2

To configure IBM DB2 connectivity for use within IBM Cognos 10 installed on Microsoft Windows, follow these instructions:

Within the IBM DB2 install directory of the database to be used for the connection, locate the ..\SQLIB\JAVA directory.
Within this directory locate and copy the db2jcc4.jar and the db2jcc_license_cu.jar files.
Within the IBM Cognos 10 install directory, locate the ..\v5dataserver\lib and the ..\p2pd\web-inf\lib directory.
Paste the db2jcc4.jar and db2jcc_license_cu.jar files into both these directories.
In order for the IBM DB2 driver to be picked up by IBM Cognos 10, the IBM Cognos 10 service will need to be stopped and started.