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 IC71362 Status: Geschlossen

DEADLATCH DURING A COMPLEX QUERY

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
One thread holds SQLP_LTRN_CHAIN__entry_latch and waits for 
SQLD_CHAIN__fullChainLatchNS. The second thread has the latches 
in the opposite order.  Deadlatch occurs.  This is timing 
related and does not always occur even with the exact same 
query.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 V9.5                                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* One thread holds SQLP_LTRN_CHAIN__entry_latch and waits      * 
* forSQLD_CHAIN__fullChainLatchNS. The second thread has       * 
* thelatchesin the opposite order.  Deadlatch occurs.  This is * 
* timingrelated and does not always occur even with the exact  * 
* samequery.                                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to product DB2 V9.5 FP7                              * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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

Lösung
First fixed in DB2 V9.5 FP7
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
21.09.2010
15.11.2010
14.04.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP7
Problem behoben lt. FixList in der Version
9.1.0.7 FixList
9.5.0.7 FixList
9.5.0.8 FixList