DB2 FOR LUW / DB2FORLUW / A10 - DB2

A SQL1224N error can occur during compilation of a query that 
satisfies the zigzag join criteria in a memory constrained 
environment. This problem can also occur if STMTHEAP size is too 
low.  If you encounter this error, the following call stack will 
be produced: 
 
sqlno_zzjn_index_analyze_gaps 
sqlno_zzjn_choose_fact_table_index 
sqlno_generate_single_fact_zzjn 
sqlno_generate_zzjn_plans 
sqlno_open_part 
sqlno_gen_partitions_for_QTB 
sqlno_plan_end_opr

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.1 Fix Pack 5                       * 
****************************************************************

Increase the size or use the AUTOMATIC setting of STMTHEAP.

First fixed in DB2 version 10.1 Fix Pack 5

See Local Fix

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

08.12.2014
13.07.2015
13.07.2015