IBM jdbc driver bug results in exception: "java.lang.NoClassDefFoundError: sun/io/ByteToCharConverter"

JDBC probes can result in an exception, "java.lang.NoClassDefFoundError: sun/io/ByteToCharConverter". This is believed to be the result of a bug in the DB2 JDBC driver as documented here: http://www-01.ibm.com/support/docview.wss?uid=swg1IC74895.

The IBM driver is calling an internal class in the Sun JRE, and Oracle / Sun removes the class. There is an update for the driver that addresses the issue but also requires adjusting a parameter.

 

Insert a non-UTF-8 character in a DB2 record and query by JDBC probe.

Workaround #1:

1. Review the description of the problem from IBM.
2. Download and install the updated DB2 package and associated driver, db2jcc.jar, following the steps in KB0551236.
3. In the agent/conf/wrapper-override.conf, add a line as follows:
   
   wrapper.java.additional.1=-Ddb2.jcc.charsetDecoderEncoder=3

Workaround #2:

Eliminate all invalid characters from the tables accessed.

These are subject to test pending access to a DB2 test environment.