DB2 FOR LUW / DB2FORLUW / A10 - DB2

Due to a timing issue in DPF environments, a statement may fail 
with this error : 
 
SQL0901N The SQL statement failed because of a non-severe system 
error. Subsequent SQL statements can be processed. (Reason "bad 
outer compare".) 
 
The same conditions can however also lead to incorrect results 
being returned. 
 
This issue may occur only if the statement access plan involves 
a merge-join. Specifically, if the access plan has a MDTQ 
operator ( Merging Directed Table Queue ) on the outer (left) 
side of the merge-join (MSJOIN). 
 
In the FODC_AppErr that is generated, the stack file of the 
failing EDU 
has "sqlri_mj" before failure. 
There is a chance that other types of SQL0901 errors may occur 
because of this problem.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to v10.1 Fix Pack 5.                                  * 
****************************************************************

The following setting disables a performance feature for MDTQ 
and avoids the issue, but it may cause some queries to run 
slower: 
 
db2set DB2_SPILL=NO_HINTS 
 
This change requires an instance recycle to take effect. 
Another option is to set the following registry value : 
db2set DB2_SORT_AFTER_TQ=YES 
this can also be supplied specific to the statement using an 
optimizer profile : 
<OPTGUIDELINES><REGISTRY><OPTION NAME='DB2_SORT_AFTER_TQ' 
VALUE='YES'/></REGISTRY></OPTGUIDELINES>

Fixed in v10.1 Fix Pack 5.

keiner bekannt / siehe Local-Fix

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

15.09.2014
14.07.2015
02.09.2016