DB2 FOR LUW / DB2FORLUW / 970 - DB2

Under rare scenarios, DB2 might abend if the following 
conditions are true: 
1) The query contains one or more comparison predicate(s) in the 
form of Substr(c1, 1, <a_constant>) <relop> <a_constant> where 
<relop> can be =, <>, >=, >, <, <=. 
2) The column c1 of predicate 1) is derived from subquery such 
that its outmost operator is either UNION ALL or GROUP BY. 
3) The subquery of 2) has an output column invovled in an 
equality join predicate. 
 
 
Error: 
 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason "Incorrect 
index: size = 
64 ix = -108.".)  SQLSTATE=58004 
 
Stack trace: 
 
sqlzeDump 
sqlzeSqlCode 
sqlno_add_to_set 
sqlno_assign_after_prds 
sqlno_assign_walk_quns_and_ff 
sqlno_each_opr 
sqlno_assign_walk_quns_and_ff

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Manually re-write the query by adding an empty string        * 
* literal                                                      * 
* using concatenation.                                         * 
****************************************************************

Manually re-write the query by adding an empty string literal 
using concatenation. 
 
change   WHERE  (Substr(t1.c1, 1, 3) = 'CONTANT') 
to 
   WHERE  ( '' + Substr(t1.c1, 1, 3) = 'CONSTANT')

not known / see Local fix

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

17.03.2015
21.10.2015
21.10.2015