Splunk DB Connect 2: Why am I getting a JDBC connection error trying to connect to a DB2 database on ZOS?

[srinathd]

While trying to connect to DB2 on a ZOS database, I'm getting the following error:

Validating connection with URL [jdbc:db2://ServerName:5124/DBName] failed: com.ibm.db2.jcc.am.SqlSyntaxErrorException:com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][t4][10509][13454][4.19.26] Connection to the data server failed. The IBM Data Server for JDBC and SQLJ license was invalid or was not activated for the DB2 for z/OS subsystem. If you are connecting directly to the data server and using DB2 Connect Unlimited Edition for System z, perform the activation step by running the activation program in the license activation kit. If you are using any other edition of DB2 Connect, obtain the license file, db2jcc_license_cisuz.jar, from the license activation kit, and follow the installation directions to include the license file in the class path. ERRORCODE=-4230, SQLSTATE=42968

I have installed db2jcc4.jar file on the Splunk machine to connect to the DB2 database. What steps do I have to follow on the Database machine to allow jdbc connections?

[Lazarix · Accepted solution]

According to the log, you're missing db2jcc_license_cisuz.jar from the classpath. Can you locate this file anywhere and put it into the classpath?

[srinathd]

This needs to be done on Splunk side?

[Lazarix]

Yes. In the same location you put the jar file for that driver (probably /opt/splunk/etc/apps/splunk_app_db_connect/bin/lib) , put that file in there also.