In this notebook, I show how to connect to a Db2 database using Python. I use the ibm_db library to manage the connection and retrieve metadata.
# If you're running this outside my environment, you may need to install these libraries:
# !pip install ibm_db ibm_db_sa ipython-sql
import ibm_db
To connect, you'll need your database credentials (hostname, username, password, etc.). Enter them below:
# Replace the placeholder values with your actual Db2 hostname, username, and password:
dsn_hostname = ""
dsn_uid = ""
dsn_pwd = ""
dsn_driver = "{IBM DB2 ODBC DRIVER}"
dsn_database = "BLUDB"
dsn_port = ""
dsn_protocol = "TCPIP"
dsn_security = "SSL"
Now I build the DSN connection string using the credentials above.
# Create the dsn connection string
dsn = (
"DRIVER={0};"
"DATABASE={1};"
"HOSTNAME={2};"
"PORT={3};"
"PROTOCOL={4};"
"UID={5};"
"PWD={6};"
"SECURITY={7};").format(dsn_driver, dsn_database, dsn_hostname, dsn_port, dsn_protocol, dsn_uid, dsn_pwd,dsn_security)
print(dsn)
DRIVER={IBM DB2 ODBC DRIVER};DATABASE=BLUDB;HOSTNAME=6667d8e9-9d4d-4ccb-ba32-21da3bb5aafc.c1ogj3sd0tgtu0lqde00.databases.appdomain.cloud;PORT=30376;PROTOCOL=TCPIP;UID=pgs19748;PWD=KiuPxHWac5RXkYqI;SECURITY=SSL;
Now I establish the connection to the database.
try:
conn = ibm_db.connect(dsn, "", "")
print ("Connected to database: ", dsn_database, "as user: ", dsn_uid, "on host: ", dsn_hostname)
except:
print ("Unable to connect: ", ibm_db.conn_errormsg() )
Connected to database: BLUDB as user: pgs19748 on host: 6667d8e9-9d4d-4ccb-ba32-21da3bb5aafc.c1ogj3sd0tgtu0lqde00.databases.appdomain.cloud
If you see the connection message, you're all set! Otherwise, check your credentials and try again.
# Retrieve Metadata for the Database Server
server = ibm_db.server_info(conn)
print ("DBMS_NAME: ", server.DBMS_NAME)
print ("DBMS_VER: ", server.DBMS_VER)
print ("DB_NAME: ", server.DB_NAME)
DBMS_NAME: DB2/LINUXX8664 DBMS_VER: 11.05.0700 DB_NAME: BLUDB
# Retrieve Metadata for the Database Client / Driver
client = ibm_db.client_info(conn)
print ("DRIVER_NAME: ", client.DRIVER_NAME)
print ("DRIVER_VER: ", client.DRIVER_VER)
print ("DATA_SOURCE_NAME: ", client.DATA_SOURCE_NAME)
print ("DRIVER_ODBC_VER: ", client.DRIVER_ODBC_VER)
print ("ODBC_VER: ", client.ODBC_VER)
print ("ODBC_SQL_CONFORMANCE: ", client.ODBC_SQL_CONFORMANCE)
print ("APPL_CODEPAGE: ", client.APPL_CODEPAGE)
print ("CONN_CODEPAGE: ", client.CONN_CODEPAGE)
DRIVER_NAME: DB2CLI.DLL DRIVER_VER: 11.05.0600 DATA_SOURCE_NAME: BLUDB DRIVER_ODBC_VER: 03.51 ODBC_VER: 03.01.0000 ODBC_SQL_CONFORMANCE: EXTENDED APPL_CODEPAGE: 1252 CONN_CODEPAGE: 1208
Closing the Connection¶
Always close your database connections to free up resources.
ibm_db.close(conn)
Summary¶
In this notebook, I demonstrated how to connect to a Db2 database, retrieve metadata, and close the connection using Python.
Notebook and analysis by Mohammad Sayem Chowdhury.
All code and explanations are my own. This notebook is shared under the MIT License.