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 Environment variables for secure credential storage to learn more about Domino environment variables.

Usage

See ibm_db 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 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