DB2 FOR LUW / DB2FORLUW / 980 - DB2

A query being compiled that has a local predicate (LOCPRD) with 
an empty string literal, i.e., '', may cause the instance to 
abend if the following conditions are satisfied: 
 
1) The column (COMPCOL) in LOCPRD is equivalent to another 
column (OTHCOL), e.g., via a join 
2) OTHCOL is also involved in a local predicate (OTHLOCPRD) 
3) LOCPRD is either an equi-join or non-equi-join predicate 
4) OTHLOCPRD is an equi-join predicate 
5) OTHCOL and COMPCOL are both string-type columns 
 
The stack trace from such an abend will look something like: 
 
sqlrxcp1 
sqlnr_seldel_test 
sqlnr_upddelpd_cond 
sqlnr_seq 
sqlnr_rcc 
sqlnr_magic_detail_action 
...

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.8 Fix Pack 3 or later.              * 
****************************************************************

Manually rewrite the query by adjusting the empty strings in 
the2 predicates involved to have the same length as the columns 
 they are being compared against using spaces, e.g., 
VARCHAR_4_COL = '' 
can be safely adjusted to: 
VARCHAR_4_COL = '    '

DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

First fixed in DB2 Version 9.8 Fix Pack 3.

not known / see Local fix

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

16.09.2010
07.06.2011
07.06.2011

9.8.FP3