Using JDBC for running reports without DB2 client

[Daljith]

My Cognos servers do not have DB2 client installed on them. But the reports run fine. When I checked the Database connections, I found the JDBC works fine and hence the reports are executed through JDBC. If anyone can help in understanding. How does JDBC work without DB2 client installed on the Cognos server and how is it configured.
And is it possible to apply SSL encryption on JDBC connectiions.

[MFGF]

My Cognos servers do not have DB2 client installed on them. But the reports run fine. When I checked the Database connections, I found the JDBC works fine and hence the reports are executed through JDBC. If anyone can help in understanding. How does JDBC work without DB2 client installed on the Cognos server and how is it configured.
And is it possible to apply SSL encryption on JDBC connectiions.

Hi,

When configuring a DB2 data source within Cognos 10, there are two tabs you can enter details into - one is for CLI (the DB2 native client) and one is for JDBC. It's entirely possible to have one set up properly without the other - they are two different methods of connecting Cognos 10 to DB2. The CLI connection requires you to have the DB2 native client libraries installed on the Cognos server (and to have the remote DB2 database server and database name cataloged so the local client can see it). On the CLI tab in Cognos, you simply add the name of the database, and Cognos interrogates the local DB2 client to see if that database is known. The JDBC connection requires you to have the DB2 JDBC files (jar file and license file) copied (as a one-off exercise) into your Cognos 10 install folder structure and it then uses these to connect directly to a database on a remote server - normally on port 50000. When configuring the JDBC tab in the database connection in Cognos, you specify the remote DB2 server, the port number and the database name to use. Provided you are using the Type 4 JDBC driver for DB2, the native client is not needed for this connection.

Cheers!

MF.

[Daljith]

Thanks Meep, this helped in understanding me. I checked that my servers have files that are required for jdbc connectivity. Thanks for that.
Can you help with another query as well regarding how to apply SSL encryption for DB2 connections in Cognos?

[MFGF]

Thanks Meep, this helped in understanding me. I checked that my servers have files that are required for jdbc connectivity. Thanks for that.
Can you help with another query as well regarding how to apply SSL encryption for DB2 connections in Cognos?

Not something I've ever done, sorry.

MF.