All Apps and Add-ons

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

SplunkDash
Motivator

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.

 

 

 

Labels (3)
Tags (1)
0 Karma
1 Solution

scelikok
SplunkTrust
SplunkTrust

Hi @SplunkDash,

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

If this reply helps you an upvote and "Accept as Solution" is appreciated.

View solution in original post

scelikok
SplunkTrust
SplunkTrust

Hi @SplunkDash,

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

If this reply helps you an upvote and "Accept as Solution" is appreciated.

scelikok
SplunkTrust
SplunkTrust

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

 

 

If this reply helps you an upvote and "Accept as Solution" is appreciated.

SplunkDash
Motivator

@scelikok,

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

 

0 Karma

scelikok
SplunkTrust
SplunkTrust

Hi @SplunkDash,

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

If this reply helps you an upvote and "Accept as Solution" is appreciated.

SplunkDash
Motivator

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!  

Tags (1)
0 Karma

scelikok
SplunkTrust
SplunkTrust

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

If this reply helps you an upvote and "Accept as Solution" is appreciated.

SplunkDash
Motivator

Hello @scelikok ,

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

 

Tags (1)
0 Karma

scelikok
SplunkTrust
SplunkTrust

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. 

If this reply helps you an upvote and "Accept as Solution" is appreciated.
0 Karma

SplunkDash
Motivator

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!

 

0 Karma
Get Updates on the Splunk Community!

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.2.2403! Analysts can ...

Stay Connected: Your Guide to July and August Tech Talks, Office Hours, and Webinars!

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...