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.
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
Where does that go? In the gui?