DB2 FOR LUW / DB2FORLUW / A10 - DB2

Certain queries may experience a trap under certain conditions 
 
a) The query contain equality join predicates where at least one 
of the operands is an expression or if the operands are of 
different datatypes. 
b) At least one input to the join is a nested sub-select or view 
that contain the GROUP BY, UNION, INTERSECT or EXCEPT clauses. 
b) The query contains additional local predicates on the input 
data described in (b) such as 
 
    col1 LIKE pattern 
    SUBSTRING(col1,1,constant) [ <, <=, =, >=, > ] constant 
 
    under Varchar2 compatibility mode the following predicate 
may also be susceptible 
      varchar_column [ <, <=, =, >=, > ] char_column 
      varchar_column [ <, <=, =, >=, > ] char_constant 
 
Possible Trap Stack: 
 
sqlno_is_subset 
sqlno_prop_twin 
sqlno_pred_build_eq_classes

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.1 Fix Pack 6                               * 
****************************************************************

First fixed in DB2 10.1 Fix Pack 6

not known / see Local fix

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

22.06.2016
02.03.2017
02.03.2017