DB2 JDBC Connection from Databricks cluster

Karl — Wed, 28 Aug 2024 15:12:07 GMT

Has anyone successfully connected to a DB2 database on ZOS from a Databricks cluster using a JDBC connection?

I also need to specify an SSL certificate path and not sure if I need to use an init script on the cluster to do so.

Any examples would be very much appreciated.

Thank you.

Re: DB2 JDBC Connection from Databricks cluster

Ayushi_Suthar — Tue, 04 Feb 2025 08:03:13 GMT

Hi @Karl , Greetings!

I've outlined the steps below to connect from Databricks to IBM DB2 using JDBC:

Step 1: Obtain the DB2 JDBC Driver

Step 2: Attach JDBC Driver to Cluster

Step 3: Create a Notebook and Connect to IBM DB2

Follow the provided documentation to establish the JDBC connection.
Execute the cell to establish the JDBC connection.
Once connected, execute SQL queries in subsequent cells to interact with the IBM DB2 database.

JDBC URL: jdbc:db2://host-name:50001/BLUDB:sslConnection=true;
Reference Document: IBM DB2 for z/OS JDBC Connectivity Guide

By following these steps, you can establish a JDBC connection from Databricks to your IBM DB2 database and execute SQL queries for data interaction.

Please let me know if this helps and leave a like if this information is useful, followups are appreciated.

Regards,

Ayushi

FRB1984 — Mon, 04 Aug 2025 21:59:14 GMT

How do I install the db2 jar lib without the libraries tab? Is there a way to to it on init script ?