home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList