DB2 FOR LUW / DB2FORLUW / 970 - DB2

Under rare scenarios, DB2 might return a SQL0901N error message 
when the following conditions are satisfied. 
 
A. The query has a Left Outer Join 
B. There is a 'IS NULL' predicate on the null producing side of 
the left join. 
C. The column used in the IS NULL predicate is also used in 
another predicate 
 
Example: 
 
select t1.ID 
  from t1 
    left outer join t2 
    on t1.ID = T2.ID 
    left outer join t3 <--condition 1 
    on t2.ID = t3.ID 
  where 
    (t2.c2 = 'VVVV0001' or t3.c2='VVVV0001')  <--condition 3 
    and t3.c2 is null;  <--condition 2 
 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason "Had 
troubles while removing an unreferenced QNC.".)  SQLSTATE=58004 
 
Similar stack will be dumped in the Trap file: 
 
ossDumpStackTraceEx 
OSSTrapFile::dumpEx 
sqlo_trce 
sqloDumpDiagInfoHandler 
__restore_rt 
pthread_kill 
sqloDumpEDU 
sqldDumpContext 
sqlrr_dump_ffdc 
sqlzeDumpFFDC 
sqlzeSqlCode 
sqlnn_erds 
sqlnr_Manual2NativeAJ 
sqlnr_optprep 
sqlnr_optprep_action 
sqlnr_comp

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 8                        * 
****************************************************************

1. Set the following registry variable 
       db2set DB2COMPOPT=327685,67108864 
2. Recycle the instance

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 8

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC88197 IC90932 
follow-up : 

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

19.09.2012
15.04.2013
15.04.2013

9.7.FP8