topic db connect to db2... in Splunk Search

db connect to db2...

a212830 — Mon, 28 Sep 2020 14:13:46 GMT

Hi,

I'm trying to connect to a DB2 db, via DB Connect and ODBC. I keep getting some generic error (see below). Has anyone seen this? Is there anything else that needs to be done when using ODBC?

Encountered the following error while trying to save: In handler 'dbx-databases': Unknown error while validating database connection

Edit:

I noticed the following in th "Recent Java Bridge errors" search:

3:37:00.942 PM

2013-07-02 15:37:00,942 DEBUG Error waiting for process: Java process returned error code 127! Error: Initializing Splunk context... Environment: SplunkEnvironment{SPLUNK_HOME=/apps/splunk/splunk,SPLUNK_DB=/apps/splunk/splunk/var/lib/splunk} Configuring Log4j... /apps/java/jdk1.7.0_10/bin/java: symbol lookup error: /apps/java/jdk1.7.0_10/jre/lib/amd64/libJdbcOdbc.so: undefined symbol: SQLAllocEnv

It seemps to pop up whenever I try to establish this connection.

Re: db connect to db2...

dwaddle — Tue, 02 Jul 2013 20:31:12 GMT

This looks like the JDK does not have the DB2 libraries in PATH / CLASSPATH. You should not need to use JDBC -> ODBC -> DB2, as DB2 has a perfectly good "mode 4" (all Java code) driver that should work with DB connect without issue.

You will want the "IBM Data Server Driver for JDBC and SQLJ", which is (today at least) available from http://www-01.ibm.com/support/docview.wss?rs=4020&uid=swg21385217 .

When using this driver, the JDBC connect string should be formatted similar to:

jdbc:db2://destination.db2.host.name.company.com:50001/DBNAME

Re: db connect to db2...

a212830 — Mon, 15 Jul 2013 18:06:15 GMT

Where does that go? In the gui?