|
Problem IC97639
|
Status: Closed |
SLOW CONCURRENT INSERTS INTO LARGE TABLE |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
The problem is first fixed in DB2 version 10.5.0.4. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.11.2013
23.01.2015
23.01.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
