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

Contention on SQLP_LTRN_CHAIN__ENTRY_LATCH after lock escalation is
interrupted degrades performance

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
Interrupting a lock escalation may result in a latch not being 
released, which in turn may cause subsequent latch contention, 
resulting in performance degradation. 
 
The problem can occur on version 9.7 fix pack 10 or version 10.5 
fix pack 5 or 6 only. 
Version 10.1 is not affected. 
 
Analysis of the performance problem will show a latch wait on 
the SQLP_LTRN_CHAIN__entry_latch.  The latch may or may not have 
an owner, and the owner may or may not be the same transaction 
that is requesting the latch. 
 
Waiting on latch type: (SQLO_LT_SQLP_LTRN_CHAIN__entry_latch) - 
Address: (7000001c2638260), Line: 106, File: sqlplsc.C
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to the latest fix pack.                              * 
****************************************************************
Local-Fix:
Try to avoid lock escalation or interrupting a lock escalation.
Lösung
Problem is first fixed in DB2 UDB version 10.5 fix pack 7.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
02.04.2015
20.01.2016
20.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList