About Domino
Domino Data LabKnowledge BaseData Science BlogTraining

Connect to IBM db2

You can connect to IBM db2 using a Data Source or directly.

IBM db2 Data Source

Your administrator must create a Data Source for this data store for you to use.

After your administrator has created the Data Source, you can work with it in your project as usual.

Direct connection

Connect directly to IBM db2 from Domino. You must have network connectivity between IBM db2 and your Domino deployment.

Warning
 Domino does not officially support this method. We provide this information as a courtesy.

Python and ibm_DB2

Domino recommends the ibm_DB2 package for interacting with DB2 databases from Python.

Environment setup

Use the following Dockerfile instruction to add ibm_db to your environment.

This instruction assumes you already have pip installed.

USER root
RUN pip install ibm_db ibm_db_sa
USER ubuntu

Credential setup

Set the following Domino environment variables to store secure information about your DB2 connection.

  • db_username

  • db_password

See Secure Credential Storage to learn more about Domino environment variables.

Usage

See Python support for IBM Db2 for LUW, IBM Informix and IBM Db2 for z/OS for detailed information about how to use the package. The following is an example for connecting to DB2 with ibm_db where:

  • You have set up the environment variables with the db_username and db_password.

  • You’ve replaced my.host.name with the host name for your machine.

import ibm_db
import ibm_db_dbi
import pandas as pd

hostname = 'my.host.name'
port = 50001
username = os.environ['db_username']
password = os.environ['db_password']

def query_db(sql):
 ibm_db_conn = ibm_db.connect("DATABASE=IBMPROD;HOSTNAME={};PORT={};PROTOCOL=TCPIP;UID={};PWD={};".format(hostname, port, username, password), "", "")
 conn = ibm_db_dbi.Connection(ibm_db_conn)

 df = pd.read_sql_query(sql, conn)
 ibm_db.close(ibm_db_conn)
 return df

sql_cmd = """

SELECT
 *
FROM
 table

"""

df_cmd = query_db(sql_cmd)

df_cmd

See Connecting to an IBM database server in Python.

R and ibmdbR

Domino recommends the imbdbR library for interacting with DB2 databases from R.

Environment setup

Use the following Dockerfile instruction to add ibmdbR to your environment.

USER root
RUN R -e 'install.packages("ibmdbR")'
USER ubuntu

Usage

See the imbdbR documentation for information about how to use the package.

Next steps