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 |