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 IT07899 Status: Geschlossen

PARTIAL AGGREGATION OPERATOR CAN CAUSE MEMORY CORRUPTION LEADING TO DB2
INSTANCE ABEND

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
Partial Aggregation operators (PED, PEA) may cause DB2 to abend 
due to a trap from invalid memory access and/or memory 
corruption.  This occurs due to writing past the end of an 
assigned memory range when either of the following occurs : 
- SORTHEAP has been dynamically reduced since the SQL statement 
was initially compiled, such as in an environment where STMM 
automatically tunes SORTHEAP 
- The sort reservation available to the operator is reduced due 
to throttling, i.e. the total sort reservation is approaching or 
exceeding SHEAPTHRES_SHR 
 
DB2 versions 10.1 and higher are vulnerable 
 
The db2diag.log will indicate that available memory is reduced 
as in the message below, though note that this alone is not 
enough to indicate the problem will definitely occur.  There 
must be an additional rare/specific shortage range resulting 
from the reduction which causes a logic error. 
 
XXXXXXXXXXXXXXXXXXXXXXXXXXXX        LEVEL: Warning 
EDUID   : XXXXX                EDUNAME: db2agent (XXXXX) 0 
FUNCTION: DB2 UDB, runtime interpreter, sqlriPEXInitHashTable, 
probe:3229 
MESSAGE : Partial Early Aggregation/Distinct running with 
reduced memory 
 
The trap symptoms can vary greatly due to the various 
side-effects resulting from memory corruption.  A common trap 
will have "Pea" in the function stack, such as: 
_intel_fast_memcpy 
sqlri_hsjnUnFormatPayload 
sqlriPeaPassAggValues 
sqlriPeaPassNonEmptyRec 
sqlriPeaEOF 
sqlripea
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All systems are vulnerable                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 7                       * 
****************************************************************
Local-Fix:
Disable partial aggregation by the following : 
  db2set DB2_REDUCED_OPTIMIZATION="NO_PEA,NO_PED" 
  recycle the instance 
 
This is an internal registry variable setting to workaround this 
problem.  The setting should be removed upon upgrade to the Fix 
pack level containing this fix : 
   db2set DB2_REDUCED_OPTIMIZATION= 
   recycle the instance
Lösung
Problem first fixed in DB2 Version 10.5 Fix Pack 7
Workaround
see Local Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
24.03.2015
16.02.2016
16.02.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList