This topic describes how to connect directly to IBM db2 from Domino. You must have network connectivity between IBM db2 and your Domino deployment.
Domino recommends the ibm_DB2 package for interacting with DB2 databases from Python.
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
anddb_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
Domino recommends the imbdbR library for interacting with DB2 databases from R.