DB2 - Problembeschreibung
Problem IC65215 | Status: Geschlossen |
DB2 CAN CRASH REMOVING DUPLICATE PREDICATES FROM THE OPTIMIZERS REWRITTEN QUERY | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
DB2 may trap with SIGSEGV (Signal #11) in the sqlnr_optprep function if the optimizers rewritten query has duplicate predicates. When removing these duplicate predicates, we may reference an already dereferenced piece of memory to cause the segmentation fault. The trap file produced will have the below stack: __res_state sqlnr_optprep sqlnn_cmpl sqlnn_cmpl sqlra_compile_var sqlra_find_var sqlra_get_var sqlrr_prepare | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users who run queries * **************************************************************** * PROBLEM DESCRIPTION: * * DB2 may trap with SIGSEGV (Signal #11) in the * * sqlnr_optprepfunction if the optimizers rewritten query has * * duplicatepredicates. When removing these duplicate * * predicates, wemay reference an already dereferenced piece of * * memory tocause the segmentation fault.The trap file produced * * will have the below * * stack:__res_statesqlnr_optprepsqlnn_cmplsqlnn_cmplsqlra_compil **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 v9.5 FP6 or newer. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
Upgrade to DB2 v9.5 FP6 or newer. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC65218 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 18.12.2009 25.05.2010 25.05.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |