|
Problem IC98311
|
Status: Closed |
DB2 CAN TRAP WHEN COMPILING A SQL STATEMENT THAT FITS THE CRITERIA FOR ZIGZAG JOIN |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
DB2 can trap when compiling a SQL statement that fits the
criteria for zigzag join. Refer to the topic "Ensuring that
queries fit the required criteria for the zigzag join" in DB2
InfoCentre for details about the criteria.
The stack traceback can be one of the following:
sqlno_prop_classify_ra_type
sqlno_prop_temp
TEMP
sqlno_crule_dam_stream
sqlno_zzjn_massage_snowflake_plan
sqlno_zzjn_generate_snowflake_plan
sqlno_generate_single_fact_zzjn
sqlno_generate_zzjn_plans
or
sqlno_cost_iot_temp
sqlno_cost_temp
sqlno_prop_temp
TEMP
sqlno_crule_dam_stream
sqlno_zzjn_massage_snowflake_plan
sqlno_zzjn_generate_snowflake_plan
sqlno_generate_single_fact_zzjn
sqlno_generate_zzjn_plans |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 Fix Pack 4 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Upgrade to DB2 Version 10.1 Fix Pack 4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.12.2013
25.08.2014
08.06.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.4
|
 |
