|
Problem IC62347
|
Status: Geschlossen |
CONTENTION ON FILELISTLATCH DUE TO TRUNCATE OF DECLARE GLOBAL TEMPOIRARY TABLES DURING COMMIT |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - 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: *
* users of declared global temporary tables created with 'on *
* commit delete rows' *
****************************************************************
* PROBLEM DESCRIPTION: *
* If a declared global temporaray table (DGTT) is created with *
* the "ON COMMIT *
* DELETE ROWS" option 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, latch *
* contention *
* develops *
* *
* Stack of latch contenting agent will look like so *
* *
* *
* sqloSpinLockConflict *
* getFileHandle *
* sqlbSMSGetOpenInfo *
* sqlbSMSTruncateObject *
* sqlbTruncateObject *
* sqldTableTruncate *
* sqlrl_userTempDelete *
* sqlrl_userTempSubActions *
* sqlrl_userTempPostCleanup *
* sqlrrcom *
* sqlrr_commit *
****************************************************************
* RECOMMENDATION: *
* upgrade to Version 9.5 Fix Pack 5 *
**************************************************************** |
| 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.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
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
|
| Lösung |
Fixed in Version 9.5 Fix Pack 5 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC64316
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 03.08.2009
04.01.2010
04.01.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.5
|
 |
