Has anyone setup Logstash to extract data from DB2 on z/OS? I had it working about four weeks ago, but after the holidays, something had changed so that I was getting this error related to the .jar / license files.
The error reported is:
Java::ComIbmDb2JccAm::SqlSyntaxErrorException: [jcc][t4][4.16.53] 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 logstash installed in /opt/logstash and my config file is using:
jdbc_driver_library => "/opt/IBM/db2jcc4.jar"
jdbc_driver_class => "com.ibm.db2.jcc.DB2Driver"
To cover my bases, I have placed these .jar files in both /opt/IBM/ as well as /opt/logstash/
Is the possible problem that Logstash isn't finding these .jar files? Or, something more tied to the DB2 JDBC driver and license for z/OS?