|
Problem IC95254
|
Status: Geschlossen |
POSSIBLE HANG IN INDEX CLEANUP LOGIC WHEN MULTIPLE ASYNCHRONOUS CLEANUP OPERATIONS ARE ACTIVE ON THE SAME TABLE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
If a partitioned table has a global index and multiple
partitioned are detached at once, then the Asynchronous
Background Processing will start a number of db2taskp EDUs to
perform the Asynchronous Index Cleanup.
It is possible that these EDUs will start contending with each
other over a particular area of the index and they get stuck in
an endless loop.
Taken call stacks repeatedly should show a pattern where these
stacks can be seen :
sqloWaitEDUWaitPost
sqlplWaitOnWP
sqlplMakeNewRequestNonSD
sqlplrq
sqlilidx
sqliTryToMerge
sqliCleanupKeysOnLeaf
procLeaf2Del
... |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 10.5.0.3. *
**************************************************************** |
| Local-Fix: |
temporarily limit the number of ABP tasks to 1 by setting :
db2set DB2_PMODEL_SETTINGS=MAX_BACKGROUND_SYSAPPS:1 |
| verfügbare FixPacks: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Lösung |
The problem is first fixed in DB2 version 10.5.0.3. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.08.2013
02.12.2013
02.12.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
