topic Re: Splunk DB Connect in All Apps and Add-ons

Splunk DB Connect

Poojita — Thu, 27 Nov 2014 07:26:33 GMT

Hi..

I used Splunk DB Connect to connect to DB2 on zOS but when i try to save database values in the splunk console i get the following error "Encountered the following error while trying to save: In handler 'databases': Error validating database: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-142, SQLSTATE=42612, SQLERRMC=null, DRIVER=4.16.53"

Also I edited the database config file in the /$SPLUNK_HOME/etc/apps/dbx/local but i am not sure if its correct.

Guide me on the same. Thanks in advance.

Re: Splunk DB Connect

richgalloway — Thu, 27 Nov 2014 14:00:39 GMT

We can't tell if your config file edits are correct without knowing what they are.

Re: Splunk DB Connect

richgalloway — Thu, 27 Nov 2014 14:04:16 GMT

A similar question was answered here: http://answers.splunk.com/answers/117024/splunk-db-connect-db2.html

Re: Splunk DB Connect

Poojita — Fri, 28 Nov 2014 03:56:35 GMT

database_types.confg file looks something like this:

[db2zOS]
displayName = DB2 on zOS
jdbcDriverClass= com.ibm.db2.jcc.DB2Driver
defaultPort = 591
connectionUrlFormat = jdbc:db2//{0}:{1}/{2}
testQuery = SELECT current date FROM sysibm.sysdummy1;

I checked the link which u posted and i had referred this link to edit the config file but the error remains the same. I dont know where i am going wrong.

Re: Splunk DB Connect

richgalloway — Fri, 28 Nov 2014 14:53:24 GMT

See this answer. http://answers.splunk.com/answers/121057/error-in-db2-connectivity-with-splunk-db2.html

Re: Splunk DB Connect

Poojita — Mon, 01 Dec 2014 02:56:56 GMT

Thank u 🙂 This helped me 🙂