Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC98368 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
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 Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 FP 10                                     * 
****************************************************************
Local Fix:
Disable automatic SORT tuning.
Solution
Upgrade to DB2 9.7 FP 10
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
17.12.2013
04.02.2015
04.02.2015
Problem solved at the following versions (IBM BugInfos)
9.7.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.10 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.