DB2 FOR LUW / DB2FORLUW / A50 - DB2

In DB2 For LUW version 10.5 Fix Pack 2 and earlier releases, a 
character string host variable cast to a BLOB data type would be 
converted to binary data without code page conversion from the 
client code page.  A change was made in DB2 For LUW version 10.5 
Fix Pack 3 that caused the host variable data to be converted to 
the database code page before the cast to BLOB occurs.  This 
occurs for both implicit and explicit casts. 
 
This was deemed an incompatible change and has been rolled back 
in version 10.5 Fix Pack 4. 
 
For example, assuming your application code page is 819 and your 
database code page is 1208, consider the following host 
variables: 
 
unsigned char r1[10] = {'ﾄ'}; 
unsigned char r2[10] = {'ﾁ'}; 
unsigned char r3[10] = {'ﾈ'}; 
 
If these values are input to a BLOB cast, in version 10.5 Fix 
Pack 2 and earlier releases the result (in HEX notation) of the 
BLOB cast for each host variable would be: 
 
r1 = 'E4  ' 
r2 = 'FC  ' 
r3 = 'EA  ' 
 
In version 10.5 Fix Pack 3, the result (in HEX notation) of the 
BLOB cast for each host variable would be: 
 
r1 = 'C3A4' 
r2 = 'C3BC' 
r3 = 'C3AA'

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 For LUW version 10.5 Fix Pack 3                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 For LUW version 10.5 Fix Pack 4.              * 
****************************************************************

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

The problem is fixed in DB2 For LUW version 10.5 Fix Pack 4.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

09.07.2014
08.09.2014
08.09.2014