DB2 FOR LUW / DB2FORLUW / A10 - DB2

This is a timing issue that can happen when the following 
conditions are true: 
 
1) STMM: 
- altering a buffer pool 
- holding SQLO_LT_SQLB_BufferPool__prevBPDCachingLatch 
- waiting on page cleaner waitpost 
 
Stack trace: 
sqloWaitEDUWaitPost 
sqlbPauseCleanerGroup 
sqlbFinalizeRTBPState 
sqlbAlterBufferPoolAct 
 
2) Page cleaner: 
- waiting on an exclusive latch for page P1 
 
Stack trace: 
sqloltch_notrack 
sqlbClnrAsyncWriteSetup 
sqloDispatchNBlocks 
sqloLioReadWriteNBlocks 
sqlbClnrDispatchSomeAIO 
sqlbClnrWriteSerializeIOList 
sqlbClnrWritePages 
sqlbClnrFindWork 
 
3) Any EDU driving a flush of the dirty list by writing a log 
record, e.g. 
 
a) Index manager adding an index key: 
- holding an exclusive latch on page P2 
- holding SQLO_LT_SQLP_DBCB__add_logspace_sem 
- waiting on SQLO_LT_SQLB_BufferPool__prevBPDCachingLatch 
 
Stack trace: 
sqlbFlushForDLSubset 
sqlbFlush 
sqlbflshConditional 
sqlpgResSpace 
sqlpWriteLR 
sqliakn 
sqlischa 
sqlischa 
 
b) At the same time, another Index manager EDU holding page P1, 
e.g. during runstats processing: 
- holding a shared latch on page P1 
- waiting on a shared latch on page P2 
 
Stack trace: 
sqlbfix 
sqlifix 
sqliFixPageWithChildPtr 
sqlischs 
sqlistat 
sqldIndexStats 
sqlrLocalRunstats 
sqlrrsta 
sqlrr_runstats_DA

**************************************************************** 
* USERS AFFECTED:                                              * 
* See Error Description                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 for Linux, UNIX, and Windows version 10.1 Fix * 
* Pack 2                                                       * 
****************************************************************

The workaround is to disable STMM.

Problem first fixed in DB2 for Linux, UNIX, and Windows version 
10.1 Fix Pack 2

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC87460 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

23.10.2012
31.12.2012
31.12.2012