DB2 - Problembeschreibung
Problem IT17259 | Status: Geschlossen |
QUERY MIGHT TRAP IN DATA PARTITION ELIMINATION OF A ZIGZAG JOIN | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problembeschreibung: | |
A query involving zigzag join might result in segmentation violation (SEGV) during data partition elimination phase (sqlri_datapart_elimination). The stack of the process will involve the following functions: ossDumpStackTraceInternal ossDumpStackTraceV98 OSSTrapFile::dumpEx sqlo_trce sqloEDUCodeTrapHandler _intel_fast_memcmp sqlrxcp2 sqlri_choose_tree_cmp sqlri_datapart_elim_evalkey sqlri_datapart_elim_set sqlri_datapart_elimination sqlriZZInit sqlriZigZagJoin sqlrihsjn sqlriSectInvoke sqlrr_smp_router sqlrr_subagent_router sqleSubRequestRouter sqleProcessSubRequest sqeAgent::RunEDU sqzEDUObj::EDUDriver sqlzRunEDU sqloEDUEntry pthread_tryjoin_np clone To temporarily circumvent the issue, you can disable zigzag join: DB2_REDUCED_OPTIMIZATION=YES,ZZJN OFF either via db2set or via an optimizer profile so that it is applied only for this specific query. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to v111 mod 1 fixpack 1 or later * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 11.1 Mod1 Fix Pack1 iFix001 for Linux, UNIX, and Windows | |
Lösung | |
v111 mod 1 fixpack 1 and all future versions will contain the fix for this. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 28.09.2016 20.12.2016 20.12.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
11.1.1.1 |