SOLVED !! - UDA-SQL-0569 Unable to load the driver manager library (db2cli.dll)

[xplorerdev]

Hi All,

I am getting the following error message when I am trying to create a New Data source in IBM Cognos Administration:

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 ( db2cli.dll ).
UDA-SQL-0571 The operating system returned an error message ( The specified module could not be found. ).

I have two virtual machines, VM1 and VM2, set up on my physical server.
VM1 has IBM DB2 9.7 installed
On VM2, I just finished installing IBM Cognos 10.2.0. I have created the Content Store database in DB2 and its connecting from the Configuration Manager. Also, I have set up Isapi, the Cognos service is starting just fine and I am able to open Cognos Connection.

I have also copied db2jcc.jar, db2jcc4.jar and db2jcc_license_cu.jar files to the IBM Installation at two locations as given in the following document: http://www.ibm.com/developerworks/data/library/cognos/infrastructure/cognos_specific/page529.html

NOTE: NO CQM. I just want the FM to work in Dynamic Query Mode.

Any advice/suggestion will be highly appreciated.

Best Regards
Dev

[MFGF]

I think if you use Type 2 JDBC you also need the DB2 client installed on the machine in order to be able to connect. If you use Type 4 it is pure JDBC and doesn't need the DB2 client. From the error you are reporting I'd assume you are using Type 2, and my guess is that this is because db2jcc.jar is the Type 2 version? You can find out by running this command:

java -cp path\db2jcc.jar com.ibm.db2.jcc.DB2Jcc -version

Try removing this so that only db2jcc4.jar and db2_jcc_license_cu.jar are remaining, and re-start your C10 service. According to the Dynamic Query Guide (chapter 3) these two files are all you need:

http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.0/dyn_query.pdf

MF.

[xplorerdev]

I think if you use Type 2 JDBC you also need the DB2 client installed on the machine in order to be able to connect. If you use Type 4 it is pure JDBC and doesn't need the DB2 client. From the error you are reporting I'd assume you are using Type 2, and my guess is that this is because db2jcc.jar is the Type 2 version? You can find out by running this command:

java -cp path\db2jcc.jar com.ibm.db2.jcc.DB2Jcc -version

Try removing this so that only db2jcc4.jar and db2_jcc_license_cu.jar are remaining, and re-start your C10 service. According to the Dynamic Query Guide (chapter 3) these two files are all you need:

http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.0/dyn_query.pdf

MF.

Hi MF. Thanks for the reply. :)

I deleted the db2jcc.jar file from the two locations, keeping only the files you suggested.  There is a change now.

Now, when I create the data source from IBM Cognos Administration, I select the Type as IBM DB2 and check the box for JDBC Connectivity. After filling all the details, when I test the connection, the CLI connection fails BUT the JDBC connection passes. I have attached a screenshot for your reference.

Any sugestions?

Best Regards
Dev

[MFGF]

Hi MF. Thanks for the reply. :)

I deleted the db2jcc.jar file from the two locations, keeping only the files you suggested.  There is a change now.

Now, when I create the data source from IBM Cognos Administration, I select the Type as IBM DB2 and check the box for JDBC Connectivity. After filling all the details, when I test the connection, the CLI connection fails BUT the JDBC connection passes. I have attached a screenshot for your reference.

Any sugestions?

Best Regards
Dev

Hi Dev,

You don't have a valid non-JDBC connection configured (and you don't have the DB2 client libraries installed locally) so it's bound to fail on that test. As long as the JDBC connection works, you are good to go using DQM. It's exactly what I would expect :)

MF.

[xplorerdev]

Hi Dev,

You don't have a valid non-JDBC connection configured (and you don't have the DB2 client libraries installed locally) so it's bound to fail on that test. As long as the JDBC connection works, you are good to go using DQM. It's exactly what I would expect :)

MF.

Thanks MF.  :)

I am now able to create new projects using FM and also use my existing projects. The models are publishing just fine. Thanks a lot for the guidance.

Since, I will be now using ONLY DQM, as suggested by you and as observed by myself now, I need not worry about the CLI Connection String.

*** CLOSING THIS THREAD ***

Best Regards
Dev