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

CONTENTION ON FILELISTLATCH DUE TO TRUNCATE OF DECLARE GLOBAL TEMPOIRARY
TABLES DURING COMMIT

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
If a declared global temporaray table (DGTT) with "ON COMMIT 
DELETE ROWS" specified, every subsequent commit will truncate 
the DGTT even if it has not been referenced in the UOW. 
Truncate processing needs  the fileListLatch and if there are 
many connections DGTTs, and frequent commits, contention 
develops on the fileListLatch 
 
Stack of latch contenting agent will look like so 
 
 
sqloSpinLockConflict 
getFileHandle 
sqlbSMSGetOpenInfo 
sqlbSMSTruncateObject 
sqlbTruncateObject 
sqldTableTruncate 
sqlrl_userTempDelete 
sqlrl_userTempSubActions 
sqlrl_userTempPostCleanup 
sqlrrcom 
sqlrr_commit
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* applications that use declared global temporary tables       * 
* defined with the "on commit delete rows" option              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* CONTENTION ON FILELISTLATCH                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to DB2 for LUW version 9.7 fixpack 1                 * 
****************************************************************
Local-Fix:
rework application logic to use DGTTs that are not created with 
the ON COMMIT DELETE ROWS option.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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 10 for Linux, UNIX, and Windows

Lösung
fixed in DB2 for LUW version 9.7 fixpack 1
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
03.11.2009
04.01.2010
04.01.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP1
Problem behoben lt. FixList in der Version
9.7.0.1 FixList