DB2 FOR LUW / DB2FORLUW / A10 - 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.1 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.

Problem first fixed in DB2 version 10.1 Fix Pack 5

See Local Fix

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

09.02.2015
13.07.2015
13.07.2015