|
Problem IT01941
|
Status: Geschlossen |
DB2 CAN TRAP WHEN COMPILING A SQL STATEMENT THAT FITS THE CRITERIA FOR ZIGZAG JOIN |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 Fix Pack 4 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Lösung |
Upgrade to DB2 Version 10.5 Fix Pack 4 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 21.05.2014
27.10.2014
27.10.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.4
|
 |
