|
Problem IC93086
|
Status: Geschlossen |
SET WRITE SUSPEND CONSISTENTLY FAILS WITH SQL1550N RC=5 WHEN THE BUFFERPOOL IS STMM ENABLED. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
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 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All users using STMM *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2 Version 10.1 FixPack 3 *
**************************************************************** |
| Local-Fix: |
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. |
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
Problem was first fixed in Version 10.1 FixPack 3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC95454 IC95542 IC95593 IC95663 IC96328 IC96343
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 15.06.2013
01.10.2013
01.10.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
