DB2 FOR LUW / DB2FORLUW / 980 - DB2

When the bufferpool is being resized by STMM, the SET WRITE 
SUSPEND command will need to wait behind the resize operations 
until it is finish.  Sometimes the resize can take a long time, 
and also it is unpredictable when STMM will trigger the resize. 
This can therefore pose a difficulty to users who hope to 
perform SET WRITE SUSPEND in fixed maintenance window. 
. 
When this issue happens, the STMM agent is usually in the 
waiting state under the following codepath. 
. 
0x09000000042E737C getConflictComplex__17SQLO_SLATCH_CAS64FCUl + 
0x244 
0x09000000042E6F1C getConflict__17SQLO_SLATCH_CAS64FCUl + 0x20 
0x090000000381680C 
sqlbSecurePageProtection__FP15SQLB_BufferPoolP8SQLB_BPDPP22SQLB_ 
HASH_BUCKET_GROUPP12SQLB_GLOBALS + 0x644 
0x0900000003814DF0 
sqlbRemInvalidPagesFromBufferPool__FP15SQLB_BufferPoolUiN32P12SQ 
LB_GLOBALS + 0x121C 
0x09000000038122D4 
sqlbDecreaseBufferpoolSize__FP15SQLB_BufferPoolP21SQLB_BP_UC_ALT 
ER_INFOP12SQLB_GLOBALS + 0x4EC 
0x0900000003810C48 
sqlbResizeBufferPool__FP15SQLB_BufferPoolP21SQLB_BP_UC_ALTER_INF 
OP12SQLB_GLOBALS + 0x230 
0x0900000003826B64 
sqlbAlterAutomaticBufferPool__FUiiP20sqle_agent_privatecb + 
0x630 
0x0900000003D8312C 
sqlrlStmmAlterBufferPool__FP20sqle_agent_privatecbPciT3 + 0x2D0 
0x0900000003DA533C 
stmmDecreaseBufferPoolInBlocks__FP21stmmCostBenefitRecord + 
0x8D8 
0x0900000003DA3AD8 
stmmResizeRecord__FP21stmmCostBenefitRecordP8sqledbcb + 0xA6C 
0x0900000003DA2470 
stmmDecreaseEntriesAndRemoveFromList__FP8sqledbcbPP21stmmCostBen 
efitRecordPUi + 0x82C 
0x0900000003DA1450 
stmmResizeEntriesAndRemoveFromList__FPP21stmmCostBenefitRecordP8 
sqledbcb + 0xBC 
0x0900000003DA0FD0 
stmmTuneMemory__FPP21stmmCostBenefitRecordP8sqledbcb + 0x110 
0x090000000439BB4C stmmMemoryTunerMain + 0x238

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users with bufferpool STMM enabled and try to issue SET      * 
* WRITE SUSPEND.                                               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Without this APAR, customer is exposed to the issue as       * 
* described in the "ERROR DESCRIPTION" section.                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.8, Fixpack 4.                       * 
****************************************************************

Avoid doing SET WRITE SUSPEND when STMM is busy (i.e. change in 
workload that causes STMM to need to resize the bufferpool). 
. 
Turn off STMM momentarily for SET WRITE SUSPEND if STMM is not 
already in action.

DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

First fixed in DB2 Version 9.8, Fixpack 4.

Avoid doing SET WRITE SUSPEND when STMM is busy (i.e. change in 
workload that causes STMM to need to resize the bufferpool). 
Turn off STMM momentarily for SET WRITE SUSPEND if STMM is not 
already in action.

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

15.07.2011
04.08.2011
04.08.2011

9.8.FP4