Create a db2 data source

[asifkb]

Hi Champs,
I have installed Cognos 11.0.8 using the "easy install" option. I have created a db2 data source also but while testing the data source, I am getting two entries 1) IBM DB2 compatible with status fail with error details QE-DEF-0285 the logon failed. QE-DEF-0325 the logon failed for following reason: RQP-DEF-0068 unable to connect to at least one database during a multi-database attach to 1 databases.
UDA-SQL-0569 unable to load the driver manager library (db2cli.dll)

The second entry is IBM DB2 (JDBC) which is getting succeeded.

How to resolve this issue as I am unable to run metadata wizard in Cognos FM?

Also Should I install db2 client database in Cognos server?

Please Advice

[Reinhard]

Hi,

for a successful non JDBC, meaning native driver, connection you need the database client installed on every application server. From there you get your driver file which you copy to cognosInstall\drivers

Regards,
Reinhard

[MFGF]

Hi Champs,
I have installed Cognos 11.0.8 using the "easy install" option. I have created a db2 data source also but while testing the data source, I am getting two entries 1) IBM DB2 compatible with status fail with error details QE-DEF-0285 the logon failed. QE-DEF-0325 the logon failed for following reason: RQP-DEF-0068 unable to connect to at least one database during a multi-database attach to 1 databases.
UDA-SQL-0569 unable to load the driver manager library (db2cli.dll)

The second entry is IBM DB2 (JDBC) which is getting succeeded.

How to resolve this issue as I am unable to run metadata wizard in Cognos FM?

Also Should I install db2 client database in Cognos server?

Please Advice

Hi,

You need to have the DB2 client libraries installed on the Cognos server for the Native Client connection type to work. It sounds like your JDBC connection is successful, though, so if you're planning to use this, you don't need to do anything further.

Cheers!

MF.