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 | |
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 |