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

A HANG RELATED TO STMM MAY BE ENCOUNTERED SHOULD AN INTERNAL COUNTER
TRACKING SHARED SORT HEAP PAGES BECOME NEGATIVE.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
In the unlikely event of the STMM internal counter for 
certain shared sort heap pages becoming negative, a hang may be 
encountered with an agent stuck whilst reserving shared sort 
space. 
 
For this to apply STMM sort heap tuning and shared sorting must 
be enabled. 
 
The hang will be characterised by an EDU with the top frames 
of its stack similar to: 
 
(the top frame may not appear in all stacks taken for the EDU) 
 
ossFetchAndAdd64 
stmmRegisterReserveSharedSortSpace 
stmmReserveUnthrottledSharedSortSpace 
sqlsReserveSharedSortSpace 
... 
 
whilst holding the SQLO_LT_stmmSort__mainLatch latch and the 
db2stmm EDU stuck waiting to acquire this latch. Other EDUs 
will be similarly waiting for this latch. 
 
As with all hangs, several stack traces should be gathered for 
all EDUs to confirm a hang before matching with a known issue. 
 
You will also be able to observe no change in the latch holder 
in repeated "db2pd -latch" command outputs.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 FP 10                                     * 
****************************************************************
Local-Fix:
Disable automatic SORT tuning.
Lösung
Upgrade to DB2 9.7 FP 10
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
17.12.2013
04.02.2015
04.02.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP10
Problem behoben lt. FixList in der Version
9.7.0.10 FixList