How to: configure ODBC connection to DB2 on iSeries

[Hans020]

Hi,

I'm trying to read data from a DB2 table on the iSeries platform. The following link (https://help.alteryx.com/2018.2/DataSources/DB2.htm) directed us to the IBM site. From that site, we downloaded and installed IBM Data Server Driver for ODBC and CLI (Windows AMD64 and Intel EM64T), Version  11.5.

In the ODBC Data Source Administrator we can see the driver was added:

When we create a new data source with this driver and click connect button to test the connection, the following error shows:

Does anyone have any experince in setting up an ODBC connection to a DB2 iSeries database?

• is any additional configuration required?
• In advanced settings, do we need to configure any CLI Parameters?
• does anyone have a sample db2cli.ini for accessing DB2 on iSeries?

Any help is appreciated.

Regards,

Hans

[WilliamR · Accepted solution]

Hello @Hans020 ,

here is a configuration which has worked on a iSeries DB2 over AS400:

(If this post helps, then please consider Accept it as the solution to help the other members find it more quickly).

[Hans020]

Hi @WilliamR,

By mistake I pressed the Accept as Solution button....

Are you saying that we have the wrong driver for iSeries? What we installed is version 11.05.00.1077.....Yours is showing 13..., DLL file is also different.

Do you happen to have a link to where we can download the one you have from IBM site?

Do you have some sample screenshots of what to configure in Alteryx to have a succesfull connection?

Regards Hans020

[WilliamR]

Hi @Hans020 ,

this is the configuration which has worked for 2 of our customers after many try of different driver version.

Sorry but I don't have any link to provide, you download the driver directly on IBM website.

The last information I can give you is this one: it has been configured with the 32bit ODBC Manager.

No special configuration just enter the name, user and password.

[bcgoh]

Thanks Much. This really solved the issue. In case if you want to know where to download the driver.
You can refer to  this link --> https://www.ibm.com/support/pages/ibm-i-access-client-solutions

Also this video help alot in setting up the driver as well --> https://www.youtube.com/watch?v=_zzbx9puBrM