DB2 FOR LUW / DB2FORLUW / 970 - DB2

Each time when we drop DGTT )Declared Global Temporary Table) in 
application, we create a new environment entry for this 
statement in the cache. Every new statements that are coming in 
have to traverse through the list of environments, holding a 
latch, making everybody else to wait. 
 
SQLO_LT_sqlra_anchor_stmt__latch - the package cache dynamic SQL 
anchor latch is one of the latch waiters.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 Users                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* PERFORMANCE DEGRADATION DUE TO A PACKAGE CACHE CONTENTION    * 
* WHEN MANY DROP DGTT STATEMENTS ARE RUNNING SIMULTANEOUSLY    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to First fixed in DB2 V9.7 FP5 to avail a fix for    * 
* this APAR.                                                   * 
****************************************************************

(i) db2set DB2_APM_PERFORMANCE=1 
(ii) Turn off statement monitor 
(iii) db2 flush package cache dynamic

DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 V9.7 FP5

keiner bekannt / siehe Local-Fix

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

15.10.2010
09.12.2011
09.12.2011

9.7.FP5