DB2 FOR LUW / DB2FORLUW / 970 - DB2

CLPPlus will throw a java.io.CharConversionException when it 
encounters invalid characters.  In most cases it is preferred 
that CLPPlus continue processing the line even if some 
characters are invalid.  CLPPlus will be modified to use Action 
Replace which will cause invalid characters to be replaced and 
processing to continue rather than throw a 
java.io.CharConversionException exception.

**************************************************************** 
* USERS AFFECTED:                                              * 
* CLPPlus Users                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 7.                       * 
****************************************************************

The CLPPlus can be configured to use Action Replace by modifying 
clpplus launch file.  On Windows the clpplus is launched by the 
clpplus.bat file located in the sqllib/bin directory. 
Approximately 240 lines into the file is the following line. 
 
"%JAVA_PATH%" -classpath "%CP%" com.ibm.clpplus.CLPPlus %* 2>NUL 
 
Once you locate this line add the string 
-Ddb2.jcc.charsetDecoderEncoder=3 after the "%JAVA_PATH%" . 
 
Below is the line with the parameter added. 
 
"%JAVA_PATH%" -Ddb2.jcc.charsetDecoderEncoder=3 -classpath 
"%CP%" com.ibm.clpplus.CLPPlus %* 2>NUL 
 
On Linux and Unix the clpplus is launchedf from the clpplus file 
located in the instance owners home directory under sqllib/bin. 
Approximately 2 lines from the end of the file is the following. 
 
$JAVA com.ibm.clpplus.CLPPlus $* 2> /dev/null 
 
Once you locate this line add ? 
-Ddb2.jcc.charsetDecoderEncoder=3? after ?$JAVA?.  Below is the 
modified line. 
 
$JAVA -Ddb2.jcc.charsetDecoderEncoder=3 com.ibm.clpplus.CLPPlus 
$* 2> /dev/null 
 
Once the CLPPlus is restarted the invalid characters will be 
replaced and java.io.CharConversionExceptions will not occur.

DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First Fixed in Version 9.7 Fix Pack 7.

The CLPPlus can be configured to use Action Replace by modifying 
clpplus launch file.  On Windows the clpplus is launched by the 
clpplus.bat file located in the sqllib/bin directory. 
Approximately 240 lines into the file is the following line. 
 
"%JAVA_PATH%" -classpath "%CP%" com.ibm.clpplus.CLPPlus %* 2>NUL 
 
Once you locate this line add the string 
-Ddb2.jcc.charsetDecoderEncoder=3 after the "%JAVA_PATH%" .

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

14.05.2012
05.11.2012
05.11.2012

9.7.FP7