DB2 FOR LUW / DB2FORLUW / 950 - 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 on V9.5 FP7 and below                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* 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.              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to DB2 V9.5 FP8 where this APAR is first      * 
* fixed.                                                       * 
****************************************************************

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

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
 

APAR first fixed in DB2 V9.5 FP8.

keiner bekannt / siehe Local-Fix

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

15.10.2010
30.06.2011
30.06.2011

9.5.FP8