Hi everyone,
Recently we are trying to connect to DB2 database in z/OS.
I downloaded the JDBC 4.0 drivers and place it into /opt/splunk/etc/apps/splunk_app_db_connect/drivers/db2jcc4-libs
as per suggestion in this thread: https://community.splunk.com/t5/All-Apps-and-Add-ons/DB-Connect-using-DB2-zOS-invalid-license/td-p/3...
But we still have this error:
[jcc][t4][10509][13454][4.27.25] 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 tried different version for the JDBC driver (4.16, 4.25, and 4.27).
From my understanding, if we are using a JDBC 4.0 driver, we should not need to provide a license file correct?
Also tried adding a new database type as per mention in this thread: https://community.splunk.com/t5/Archive/SPLUNK-DB-CONNECT-DB2/m-p/194145
[db2zOS]
displayName = DB2 on zOS
jdbcDriverClass = com.ibm.db2.jcc.DB2Driver
defaultPort = 3750
connectionUrlFormat = jdbc:db2://{0}:{1}/{2}
testQuery = SELECT 1 FROM SYSIBM.SYSDUMMY1;Still have no luck?
Any idea?
Cheers,
S
