Logstash accessing DB2 on z/OS; classpath, license issues?

Elastic Stack Logstash
1

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][10509][13454][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?

2

Good news -- I sorted out the error message, finally! Hopefully by documenting this, it will help someone else out who encounters the same error!

I ended up biting the bullet and installing DB2 Connect for Linux, and as a result, received a new set of JDBC / DB2 jar files that I pointed Logstash to. CLASSPATH=.:/opt/ibm/db2/V10.1/java/*

Pasted image752×118 4.68 KB

This did the trick, as I'm now able to connect Logstash to DB2 on z/OS, iSeries, and AIX. From what I can tell, installing DB2 Connect may have activated the license jar file, but I'm not sure.

For future reference, I was able to debug a little better when I started calling the JDBC / DB2 driver directly from the command line.

db2jcc -url jdbc:db2://:/ -user -password ********
java -cp ./db2jcc4.jar com.ibm.db2.jcc.DB2Jcc -url jdbc:db2://:/ -user -password ********

3

I believe that it should be enough to add the .lic file to the place where you have the db2 jdbc files. Worth trying.

4

HI Russ
I'm trying to startup logstash on z/os to collect data from DB2 .
But i don't now which logstash scrips may i use.
Which logstash did you use??