DB2 - Problembeschreibung
Problem IC97639 | Status: Geschlossen |
SLOW CONCURRENT INSERTS INTO LARGE TABLE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
An application hangs (very slow) when running concurrent inserts into a table. Stacks : ========================================= <<<< Holder Information (Address = 0x700000b84ae4d60) >>>> File Information: Line: 2485, File: sqldpgcache.C HoldCount: 1 ---------------------------- PID(s): 102805 (./3932468.102805.000.stack.txt) -- Line: 2485, File: sqldpgcache.C HoldCount: 1 (SQLO_LT_SQLD_PAGE_CACHE__pageCacheLatch) Agent Type: db2agent (A4P) *** Stack *** Timestamp: 2013-07-01-12.04.47.496413 0x090000000E4B7B00 releaseConflict__17SQLO_SLATCH_CAS64Fv + 0x2D4 0x090000000DE03030 sqldRefillFscrCache__FP13SQLD_DFM_WORK + 0x558 0x090000000E2DBD28 sqldSearchPageCache__FP13SQLD_DFM_WORKP15SQLD_PAGE_CACHEP16SQLD_ TABLE_CACHET3 + 0x168 0x090000000E2DBA2C sqldInsertRow__FP13SQLD_DFM_WORKi + 0x20 0x090000000E2338E0 sqldRowInsert__FP8sqeAgentUsT2UcUliPP10SQLD_VALUEP13SQLD_TDATARE CP8SQLZ_RID + 0x1084 0x090000000E2C9250 sqlrinsr__FP8sqlrr_cbUsT2iT2PP10SQLD_VALUEQ3_10sqlri_iudo11t_iud oFlags17t_iudoFlagsKernelP8SQLZ_RID + 0xB8 0x090000000E2C902C sqlriisr__FP8sqlrr_cb + 0x164 0x090000000E30BC08 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x24 0x090000000E34B74C .sqlrr_process_execute_request.fdpr.clone.1505__FP8sqlrr_cbi + 0xB20 0x090000000E405598 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x534 0x090000000E3D8400 .sqljs_ddm_excsqlstt.fdpr.clone.1641__FP14db2UCinterfaceP13sqljD DMObject + 0xDE0 0x090000000E3DA280 sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC interface + 0x7C 0x090000000E3D9BF4 .sqljsParse.fdpr.clone.137__FP13sqljsDrdaAsCbP14db2UCinterfaceP8 sqeAgentb + 0x1084 0x090000000E3E0288 @73@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x2D8 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~ <<<< Waiter Information (Address = 0x700000b84ae4d60) >>>> TOTAL WAITERS >> 1 File Information: Line: 4613, File: sqldpgcache.C ---------------------------- PID(s): 99464 (./3932468.99464.000.stack.txt) -- Line: 4613, File: sqldpgcache.C (SQLO_LT_SQLD_PAGE_CACHE__pageCacheLatch) Agent Type: db2agent (A4P) <<< Stack >>> Timestamp: 2013-07-01-12.04.47.858612 0x0900000000100158 thread_wait + 0x98 0x090000000E330E30 getConflictComplex__17SQLO_SLATCH_CAS64FCUl + 0x168 0x090000000E32FEA8 getConflict__17SQLO_SLATCH_CAS64FCUl + 0x78 0x090000000E2DEF80 sqldFindRidFromPageCacheSimple__FP13SQLD_DFM_WORKP15SQLD_PAGE_CA CHE + 0x32C 0x090000000E2DB99C sqldSearchPageCache__FP13SQLD_DFM_WORKP15SQLD_PAGE_CACHEP16SQLD_ TABLE_CACHET3 + 0x120 0x090000000E2DBA2C sqldInsertRow__FP13SQLD_DFM_WORKi + 0x20 0x090000000E2338E0 sqldRowInsert__FP8sqeAgentUsT2UcUliPP10SQLD_VALUEP13SQLD_TDATARE CP8SQLZ_RID + 0x1084 0x090000000E2C9250 sqlrinsr__FP8sqlrr_cbUsT2iT2PP10SQLD_VALUEQ3_10sqlri_iudo11t_iud oFlags17t_iudoFlagsKernelP8SQLZ_RID + 0xB8 0x090000000E2C902C sqlriisr__FP8sqlrr_cb + 0x164 0x090000000E30BC08 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x24 0x090000000E34B74C .sqlrr_process_execute_request.fdpr.clone.1505__FP8sqlrr_cbi + 0xB20 0x090000000E405598 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x534 0x090000000E3D8400 .sqljs_ddm_excsqlstt.fdpr.clone.1641__FP14db2UCinterfaceP13sqljD DMObject + 0xDE0 0x090000000E3DA280 sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC interface + 0x7C Here, all the edu coming to insert the page following the same FSCR and found the page were filled up and need to follow new FSCR to new page and again found it filled up. FSCR cache page is shared among the edus in the same DB. This fscr page caching ( sqldSearchPageCache() ) started in 9.8 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.5.0.4. * **************************************************************** | |
Local-Fix: | |
1) put the table in append mode using the APPEND ON option of the ALTER TABLE command. or 2) db2set DB2MAXFSCRSEARCH=1 db2stop/db2start. | |
verfügbare FixPacks: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Lösung | |
The problem is first fixed in DB2 version 10.5.0.4. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 13.11.2013 23.01.2015 23.01.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.4 |