home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC90894 Status: Geschlossen

POSSIBLE HANG IN INDEX CLEANUP LOGIC WHEN MULTIPLE ASYNCHRONOUS CLEANUP
OPERATIONS ARE ACTIVE ON THE SAME TABLE

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - 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.1.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.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
The problem is first fixed in DB2 version 10.1.0.3.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC95254 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
15.03.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 FixList
10.1.0.3 FixList