Description
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.
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.
Steps to Reproduce
Insert a non-UTF-8 character in a DB2 record and query by JDBC probe.
Workaround
Workaround #1:
- Review the description of the problem from IBM.
- Download and install the updated DB2 package and associated driver, db2jcc.jar, following the steps in KB0551236.
- 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.
Related Problem: PRB635705