DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to the latest fix pack.                              * 
****************************************************************

Try to avoid lock escalation or interrupting a lock escalation.

Problem is first fixed in DB2 UDB version 9.7 fix pack 11

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

31.03.2015
06.10.2015
06.10.2015

9.7.FP11