|
Problem IC64825
|
Status: Closed |
ALTER BUFFERPOOL REDUCE, STMM AND DB2STOP FORCE MAY HANG. A WRIT E SUSPEND COULDLEAD TO THIS. |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| 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. 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 Summary: |
****************************************************************
* 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 |
| available fix packs: |
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 9.5 Fix Pack 5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.11.2009
15.12.2009
23.08.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.5
|
 |
