DB2 FOR LUW / DB2FORLUW / A50 - DB2

In a rare scenario, DB2 might trap while compiling a query that 
is eligible for zigzag join processing. 
 
You will find the following in the stack trace if you encounter 
this problem: 
 
<StackTrace> 
sqloEDUCodeTrapHandler 
... 
gsignal 
abort 
... 
... 
sqlno_zzjn_generate_fact_plan 
</StackTrace>

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 5                       * 
****************************************************************

You can disable zigzag join by setting 
DB2_REDUCED_OPTIMIZATION="ZZJN OFF".  You can apply this against 
an application or specific set of statements by using an 
optimization profile that contains a REGISTRY request.  You can 
also disable zigzag join by setting the optimization level to 0 
or 1.

Probelm is fixed in DB2 Version 10.5 Fix Pack 5

keiner bekannt / siehe Local-Fix

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

17.10.2014
15.12.2014
12.06.2015