DB2 FOR LUW / DB2FORLUW / A50 - DB2

In a unicode database, running a query might return incorrect 
results if it contains a like predicate against a clob column, 
and the pattern to match contains a fullwidth underscore wild 
character (X'EFBCBF'). 
 
For example: 
create table tbl1 ( id int, cclob20oct clob(20)) 
insert into tbl1 values (1, X'F094AE8041') 
select id from tbl1 where cclob20oct like X'F094AE80EFBCBF' 
ID 
----------- 
 
  0 record(s) selected. 
 
<-- incorrect result returns : the matching row is not returned. 
 
Recall that the fullwidth underscore is a wildcard character. 
See the Information Center for details.

**************************************************************** 
* USERS AFFECTED:                                              * 
* UTF-8 databases                                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to 10.5.0.3                                           * 
****************************************************************

Use halfwidth underscore character (X'5F') instead of a 
fullwidth underscore character (X'EFBCBF').

DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
 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
 

Problem Fixed In 10.5.0.3

keiner bekannt / siehe Local-Fix

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

21.11.2013
03.03.2014
07.04.2015