DB2 - Problembeschreibung
Problem IC64825 | Status: Geschlossen |
ALTER BUFFERPOOL REDUCE, STMM AND DB2STOP FORCE MAY HANG. A WRIT E SUSPEND COULDLEAD TO THIS. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
SET WRITE SUSPEND has the ability to interrupt page cleaners, but once the page cleaners had been interrupted, they did not perform the correct sequence of disengagement, and may cause ALTER BUFFERPOOL REDUCE or STMM to indefinitely wait on some page latches. DB2STOP FORCE may also hang because it cannot properly terminate some processes/threads. The problem can happen even without a SET WRITE SUSPEND being issued. For example if you see the following stack for the stmm for an extended period of time, then you may have run into this apar. sqlorest + 0x40 sqlbRemInvalidPagesFromBufferPool__FP15SQLB_BufferPoolUiN32P12SQ LB_GLOBALS + 0xD54 sqlbDecreaseBufferpoolSize__FP15SQLB_BufferPoolP21SQLB_BP_UC_ALT ER_INFOP12SQLB_GLOBALS + 0x564 sqlbResizeBufferPool__FP15SQLB_BufferPoolP21SQLB_BP_UC_ALTER_INF OP12SQLB_GLOBALS + 0x1F8 sqlbAlterAutomaticBufferPool__FUiiP8sqeAgent + 0x738 sqlrlStmmAlterBufferPool__FP8sqeAgentPciT3P14db2UCinterfaceP5sql ca + 0x404 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * SET WRITE SUSPEND has the ability to interrupt page * * cleaners, * * but once the page cleaners had been interrupted, they did * * not * * perform the correct sequence of disengagement, and may cause * * * * ALTER BUFFERPOOL REDUCE or STMM to indefinitely wait on some * * * * page latches. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 Fix Pack 5 * **************************************************************** | |
Local-Fix: | |
Recycle the instance | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.5 Fix Pack 5. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 25.11.2009 15.12.2009 23.08.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP5 | |
Problem behoben lt. FixList in der Version | |
9.5.0.5 |