This repository was archived by the owner on Sep 24, 2025. It is now read-only.
IBM DB2 support
Lets say this are the tables imported in Jam.py:
From the BD2 server console, we can use DB2INST1 user to list the tables:
db2 list tables for all |grep WEB WEBREPORTS DBO T 2015-12-22-09.13.38.088070 WEBREPORTS_FILES DBO T 2015-12-22-09.13.38.397378 If we are connecting with DB2INST1 user from Jam.py application (or any other user, note the DBO above!), the Python ibm_db driver will report:
Traceback (most recent call last): ... ibm_db_dbi.ProgrammingError: ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "DB2INST1.webreports" is an undefined name. SQLSTATE=42704 SQLCODE=-204 ... If we create the DB aliases, the error will go away:
db2 "create alias webreports for dbo.webreports" db2 list tables for all |grep WEB WEBREPORTS DB2INST1 A 2024-09-12-12.05.02.042117 WEBREPORTS_FILES DB2INST1 A 2024-09-12-13.21.30.675683 WEBREPORTS DBO T 2015-12-22-09.13.38.088070 WEBREPORTS_FILES DBO T 2015-12-22-09.13.38.397378 After creating the alias, Jam will happily present the page:
Instead of creating the aliases, we could use the SCHEMA_NAME, however, this would need expanding the database connection form with a Schema Name.
Not sure if this is worth doing, since no one ever asked for IBM DB2 support.