DB2 - Problembeschreibung
Problem IC86557 | Status: Geschlossen |
POSSIBLE ABEND DUE TO DOUBLE FREE IN STMTHEAP MEMORY WHEN COMPILING A COMPLEX QUERY WITH MULTIPLE GROUP-BY SUBQUERIES | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When compiling a complex statement with multiple group-by sub queries, it is possible that the DB2 Query Compiler will free the same internal memory structure twice. When this happens, the problem goes undetected until the memory is reused, during the same query compilation. This may lead to a crash with possibly several signature call stacks, a few that have been observed : 1. sqlnr_pullup_rejoin_qun sqlnr_pullup_compensations sqlnr_subsume_derived_match sqlnr_subsume_match form_matches 2. sqlnr_qncdereqc sqlnr_optprep sqlnr_optprep sqlnr_comp 3. sqlnq_qtb::insert_between sqlnq_qun::insert_selbox sqlnr_insert_selbox sqlnr_optprep sqlnr_optprep_action | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade the DB2 server to V9.7 Fix Pack 8 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows | |
Lösung | |
This problem has first been fixed in V9.7 Fix Pack 8 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC89714 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 14.09.2012 29.04.2013 29.04.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP8 | |
Problem behoben lt. FixList in der Version | |
9.7.0.8 |