topic Re: Which JDBC driver required to connect to DB2 database installed on IBM AS400 / IBM I-series in All Apps and Add-ons

Which JDBC driver required to connect to DB2 database installed on IBM AS400 / IBM I-series

aashish_kumar — Tue, 05 Aug 2014 11:15:51 GMT

Hi Experts,

I am using DB Connect apps of splunk and I am able to connect to Oracle database for data input however my project requirement is to connect to DB2 database which is installed on IBM AS400 / IBM I-series.

I have tried multiple DB2 JDBC drivers but no driver is compatible for the connectivity.
Do any one of you come across such issue and found any solution for this.

Please let me know.

Thank You.
Aashish Kumar

Re: Which JDBC driver required to connect to DB2 database installed on IBM AS400 / IBM I-series

mchang_splunk — Mon, 28 Sep 2020 17:16:16 GMT

Did you follow the steps here: http://docs.splunk.com/Documentation/DBX/1.1.4/DeployDBX/Installdrivers#Step_1:_Download_driver

Any error message found in jbridge.log?

Re: Which JDBC driver required to connect to DB2 database installed on IBM AS400 / IBM I-series

aashish_kumar — Wed, 06 Aug 2014 03:31:41 GMT

I tried this. Actually the driver on this page is for DB2 and my requirement is for DB2/400 i.e. DB2 installed on I-series so these JDBC drivers are not compatible with DB2/400 database. I am getting error message regarding that JDBC driver.

Aashish

Re: Which JDBC driver required to connect to DB2 database installed on IBM AS400 / IBM I-series

johndoe23 — Tue, 09 Dec 2014 14:44:13 GMT

Hi Aashish,
I know this thread is already 5 month old. However, there is a special Windows toolset called "IBM i Acess for Windons". It ships with a special Version of ODBC for IBM i. I haven't tested it in combination with splunk DB-Connect though. But I think, you should give it a try.

Cheers

Re: Which JDBC driver required to connect to DB2 database installed on IBM AS400 / IBM I-series

yassy — Mon, 14 Jan 2019 18:42:39 GMT

hello Can you resolved it? I have the same problem
TKS

Re: Which JDBC driver required to connect to DB2 database installed on IBM AS400 / IBM I-series

yassy — Mon, 14 Jan 2019 18:42:42 GMT

hello Can you resolved it? I have the same problem
TKS

Re: Which JDBC driver required to connect to DB2 database installed on IBM AS400 / IBM I-series

yassy — Wed, 05 Jun 2019 17:43:15 GMT

Hello can you fixed it? I have the same problem. Please let me know