DB2 FOR LUW / DB2FORLUW / A10 - DB2

The following are the necessary conditions that might cause the 
problem of "0 record(s) selected" to occur: 
 
- The DB2_COMPATIBILITY_VECTOR registry variable is set to ORA 
- A "X IN (select Y from <subquery>)" query predicate. 
- X is the CHAR type, and Y is the VARCHAR type. 
 
To verify that this problem has occurred in your query, generate 
the db2exfmt command and 
search if the optimized statement contains the following: 
 
- "(Q<num>.X >= $C3 )" 
- "(Q<num>.X <= $C2)" 
 
Also, check to see if the plan details contain: 
 
- "(ORA_VARCHAR(Q<num>.X) <= $C1 )" 
-  "(ORA_VARCHAR((Q<num>.X)>= $C0)".

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.1.0.3.                             * 
****************************************************************

Rewrite the IN predicate to the EXISTS predicate: 
 
select * 
from table1 
where pk_alansawyer in 
   (select pk_christine 
   from table2); 
 
to 
 
select * 
from table1 
where exists 
   (select 1 
   from table2 where pk_alansawyer = pk_christine);

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

The problem is first fixed in DB2 version 10.1.0.3.

keiner bekannt / siehe Local-Fix

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

20.08.2013
27.09.2013
27.09.2013