DB2 FOR LUW / DB2FORLUW / 970 - 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:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix pack 8.                       * 
****************************************************************

The workaround is to disable STMM.

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 Fix pack 8.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC87456 
Nachfolger : 

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

10.10.2012
01.04.2013
01.04.2013

9.7.FP8