DB2 FOR LUW / DB2FORLUW / 970 - DB2

In Oracle compatibility mode DB2 uses blank sensitive comparison 
for vargraphic data type and lead to wrong results. 
 
Conditions to hit this APAR: 
 
1. This APAR can be hit only on Oracle compatibility so the 
following registry variable should be set. 
    "DB2_COMPATIBILITY_VECTOR=ORA" 
2. Table column should have VARGRAPHIC data type. 
3. Index should be created on that column. 
4. In the query, WHERE clause should contain LIKE predicate. 
 
Example: 
 
db2 "create table t1(c1 vargraphic(5), c2 vargraphic(5))" 
DB20000I  The SQL command completed successfully. 
 
db2 "insert into t1 values('V','A'),('V1','AB')" 
DB20000I  The SQL command completed successfully. 
 
db2 "create index idx_t1 on t1(c1)" 
DB20000I  The SQL command completed successfully. 
 
db2 "select c1 from t1 where c1 like 'V%'" 
C1 
---------- 
V1 
 
  1 record(s) selected. 
 
Expected result: 
 
C1 
---------- 
V <-- Missing row 
V1 
  1 record(s) selected.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 Fix pack 7                        * 
****************************************************************

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 DB2 version 9.7 Fix pack 7

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC87877 IC88711 
follow-up : 

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

02.05.2012
19.04.2013
19.04.2013

9.7.FP7