DB2 FOR LUW / DB2FORLUW / A10 - DB2

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.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 4                       * 
****************************************************************

Disable automatic SORT tuning.

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Upgrade to DB2 Version 10.1 Fix Pack 4

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

29.04.2014
19.08.2014
19.08.2014