DB2 - Problembeschreibung
Problem IT07276 | Status: Geschlossen |
DB2 MIGHT ABEND WHEN EXECUTING QUERY WITH INLIST PREDICATES | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
Under rare scenarios, DB2 might abend if the following conditions are true: 1) The query contains 4 or more INLIST predicates 2) Atleast 2 predicates are based on the same column 3) Atleast two INLISTs contain only constants 4) Atleast two other INLIST contain complex expressions Trap file will show SIGSEGV in following stack: sqlnr_qsort_compare_inlist_exps qsort sqlnr_sinlist2common sqlnr_qrwprep_phase2 sqlnr_prep2_action sqlnr_comp sqlnr_seq sqlnr_rcc sqlnr_exe sqlnn_cmpl sqlnn_cmpl sqlra_compile_var sqlra_find_var sqlra_get_var sqlrr_prepare | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.5 Fix Pack 7 or higher. * **************************************************************** | |
Local-Fix: | |
Merge the INLISTs based on the same column into a single list | |
Lösung | |
Fixed in DB2 version 10.5 Fix Pack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 20.02.2015 19.01.2016 19.04.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |