DB2 - Problembeschreibung
Problem IC87456 | Status: Geschlossen |
HANG DURING BUFFERPOOL FLUSH WHEN STMM IS ALTERING A BUFFERPOOL | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
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 | |
Problem-Zusammenfassung: | |
**************************************************************** * 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 * **************************************************************** | |
Local-Fix: | |
The workaround is to disable STMM. | |
Lösung | |
Problem first fixed in DB2 for Linux, UNIX, and Windows version 10.1 Fix Pack 2 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC87460 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.10.2012 31.12.2012 31.12.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |