You can connect to IBM db2 using a Data Source or directly.
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.
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. |
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 Store Project credentials 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_usernameanddb_password. -
You’ve replaced
my.host.namewith 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_cmdDomino recommends the imbdbR library for interacting with DB2 databases from R.