|
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
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 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
|
 |
