DB2 FOR LUW / DB2FORLUW / 970 - DB2

Under a rare timing scenario, ALTER TABLESPACE with LOWER HIGH 
WATER MARK command might hang due to a deadlatch in extentLatch. 
 
Here's the summary of the deadlatch scenario in extentLatch - 
 
o page cleaner A holding an S latch 
o extent mover B trying to latch in X, waiting for A 
o page cleaner A asking to latch again in S, yielding to B 
o Now, A is waiting for B who is waiting for A who is waiting 
  for B. 
 
Here's a stack dump example for the Page Cleaner i.e. 
 
Page Cleaner 
------------ 
getConflict + 0x74 
sqlbFindAndLatchExtent + 0x3F8 
sqlbFindAndLatchExtent + 0x74 
sqlbCommonWriteSetup 
sqlbClnrAsyncWriteSetup 
 
Here's a stack dump example for the Extent Mover i.e. 
 
Extent Mover 
------------ 
getConflict + 0x74 
sqlbMoveHighestExtent + 0x580 
sqlbLockAndMoveExtents + 0x2440 
sqlbExtentMovementEntryPoint + 0x56C 
sqleIndCoordProcessRequest + 0x41C

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Without this APAR, customer is exposed to the issue as       * 
* described in the "ERROR DESCRIPTION" section.                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7, Fixpack 6.                       * 
****************************************************************

n/a

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 9.7, Fixpack 6.

n/a

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

13.09.2011
18.07.2012
18.07.2012

9.7.FP6