IBM_DB - connect to AS400 - "hangs" - using pyodbc - success (w/ caveat)

[Craig Carpenter]

Description of environment

Using RHEL 7.x to connect to an AS400 thru couple of firewalls and thru a proxy configuration

 - On REHEL 7.x we have the IBM driver ( IBM i Access ODBC Driver 64-bit ) installed and using stunnel for SSL and have uploaded a cert

Using pyodbc 

 - configuration is picking up connection details from /etc/odbc.ini and connection is successful - data is returned, etc.

 - only issue is we are not getting the output parameter value thru the stored procedure call

Using ibm_db

 - db/connect information is within the script (matches the odbc.ini content plus the stunnel config)

 - result is the script just hangs -- network traffic appears to show retries....

I've seen references to a different series of ports for IBM_DB - 446/448 -- we are using 9470 - 9476 as this is the config setup on the 400

Is IBM_DB only setup to support/work with 44/448 configurations or are we missing something in the script to work with this drive and port setup?

[Saba Kauser]

Hello Craig,

Use Db2 LUW ODBC and CLI driver with ibm_db.
The driver is downloaded automatically with ibm_db installation unless you set IBM_DB_HOME env variable to an already installed location.

[Craig Carpenter]

Can you be more specific? LUW driver?

We have the iSeries Access ODBC driver installed as well and this doesn't connect at all using that drive.

[Saba Kauser]

Only the odbc driver packages(per platform) available in below link are expected to work with ibm_db.
https://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/

[kad...@us.ibm.com]

If you want to use the IBM i Access ODBC driver, you have to use pyodbc. ibm_db only works the IBM CLI interface (Db2 Connect / IBM i CLI). If you want to use ibm_db, you'll have to use Db2 Connect (and also purchase a license in order to connect to IBM i).

[Craig Carpenter]

Thanks -- we have linuxx64_odbc_cli.tar.gz installed -- guess I'm missing what the classes/driver names are for this library.