DB2 FOR LUW / DB2FORLUW / 970 - 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:                                              * 
* Apply this APAR                                              * 
****************************************************************

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

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
 

Apply this APAR

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC97793 IC97851 IC98057 IC98058 
follow-up : 

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

19.09.2013
16.12.2013
16.12.2013