|
Problem IC64316
|
Status: Closed |
CONTENTION ON FILELISTLATCH DUE TO TRUNCATE OF DECLARE GLOBAL TEMPOIRARY TABLES DURING COMMIT |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
fixed in DB2 for LUW version 9.7 fixpack 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.11.2009
04.01.2010
04.01.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
