|
Problem IT05968
|
Status: Closed |
SQL1224N ERROR DURING QUERY COMPILATION UNDER MEMORY CONSTRAINED ENVIRONMENT |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 10.1 Fix Pack 5 *
**************************************************************** |
| Local Fix: |
Increase the size or use the AUTOMATIC setting of STMTHEAP. |
| Solution |
First fixed in DB2 version 10.1 Fix Pack 5 |
| Workaround |
See Local Fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.12.2014
13.07.2015
13.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
