topic Re: How to get dbConnect Driver to resolve issue for Connection Type DB2? in All Apps and Add-ons

How to get dbConnect Driver to resolve issue for Connection Type DB2?

SplunkDash — Thu, 19 Jan 2023 22:15:09 GMT

Hello,

When I was trying to create new connection for my dbConnect, using Connection Type DB2, I am getting error message: "No Suitable Driver is Available" saying no compatible driver found in "drivers" directory. How would I get the driver installed to resolve this issue? Thank you so much in advance for your support.

Re: How to get dbConnect Driver to resolve issue for Connection Type DB2?

scelikok — Fri, 20 Jan 2023 02:11:15 GMT

Hi @SplunkDash,

You can install DB2 driver using Splunk Add-on for DB2 JDBC app.

Re: How to get dbConnect Driver to resolve issue for Connection Type DB2?

SplunkDash — Fri, 20 Jan 2023 02:35:31 GMT

Hello @scelikok

Thank you so much for your quick response. I downloaded the DB2 driver from the link you provided. But I couldn't get installation info. How would I install this driver? Our dbConnect App in installed on a server where heavy forwarder installed on it. Thank you!

Re: How to get dbConnect Driver to resolve issue for Connection Type DB2?

scelikok — Fri, 20 Jan 2023 03:10:51 GMT

Hi @SplunkDash,

There is no specific installation info. You can install it like any Splunkbase app. It should be installed on the same server that DBConnect App working.

https://docs.splunk.com/Documentation/DBX/3.11.0/JDBCDB2/Install

Re: How to get dbConnect Driver to resolve issue for Connection Type DB2?

SplunkDash — Fri, 20 Jan 2023 03:13:35 GMT

@scelikok,

I just need to install it the way we install other Splunkbase app, correct?

Re: How to get dbConnect Driver to resolve issue for Connection Type DB2?

scelikok — Fri, 20 Jan 2023 03:37:56 GMT

Hi @SplunkDash,

Yes, correct. Then DBConnect app will show the DB2 driver installed.

Re: How to get dbConnect Driver to resolve issue for Connection Type DB2?

SplunkDash — Fri, 03 Feb 2023 12:27:04 GMT

Hello @scelikok,

Thank you so much for your support to get the DB2 driver installed into one of our servers and working as expected. I have one issue with one of my clients, as the DB2 Driver version that I downloaded using your provided link and installed into my server was DB2 v4.32. But the server at the client end only support DB2 v4.29 or lower. Are there any ways I can get the DB2 Driver v4.29 or below? Your recommendation will be highly appreciated, thank you so much again!

Re: How to get dbConnect Driver to resolve issue for Connection Type DB2?

scelikok — Fri, 03 Feb 2023 14:51:13 GMT

Hi @SplunkDash,

You can download the supported driver file and copy or move the db2jcc4.jar file to the $SPLUNK_HOME/etc/apps/splunk_app_db_connect/drivers directory, reload the driver under Settings>Drivers.

https://docs.splunk.com/Documentation/DBX/3.7.0/DeployDBX/Installdatabasedrivers#IBM_DB2

Re: How to get dbConnect Driver to resolve issue for Connection Type DB2?

SplunkDash — Fri, 03 Feb 2023 15:37:51 GMT

Hello @scelikok ,

Thank you so much for your quick response, truly appreciate it. Are these open-source drivers and going to work in SPLUNK?

Re: How to get dbConnect Driver to resolve issue for Connection Type DB2?

scelikok — Tue, 07 Feb 2023 05:01:29 GMT

Hi @SplunkDash,

These are drivers provided by IBM, you should be able to download them using IBM id. And yes they will work with Splunk DB Connect.