IBM i (formerly AS/400) is a business computing platform developed by IBM, known for its reliability, stability, and long-term use in enterprise environments such as manufacturing, finance, logistics, and retail. IBM Db2 is IBM’s relational database system used to store, manage, and query business data. On IBM i systems, Db2 is tightly integrated into the operating system, providing secure and high-performance database capabilities for enterprise applications.

This article provides you an overview to connect IBM Db2 in Peliqan. Please contact support if you have any additional questions or remarks.

How to connect

Make sure to install the ibm_db Python pip module first in your Peliqan account.

In Peliqan, go to Admin > Data apps > Custom pip modules.

Search for ibm_db and click on “Apply & Restart”:

Next, implement a Data App (Python script) to read data from Db2 and e.g. write that data into tables in the data warehouse. Example:

import ibm_db

try:
    conn = ibm_db.connect(
        "DATABASE=SAMPLE;"
        "HOSTNAME=1.2.3.4;"
        "PORT=448;"
        "PROTOCOL=SOCKETS;"
        "UID=APLPELIQAN;"
        f"PWD={pq.get_secret('IBM Db2 Password')};",
    )

    st.success("Connected to IBM Dd2 successfully!")

    sql = "SELECT * FROM MYTABLE FETCH FIRST 10 ROWS ONLY"

    stmt = ibm_db.exec_immediate(conn, sql)

    rows = []

    result = ibm_db.fetch_assoc(stmt)
    while result:
        rows.append(result)
        result = ibm_db.fetch_assoc(stmt)

    st.write(rows)

    ibm_db.close(conn)

except Exception as e:
    st.error(f"Connection failed: {str(e)}")

IBM Db2 (AS/400) - Getting started in Peliqan

How to connect