DB2 FOR LUW / DB2FORLUW / A10 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.1.0.4.                             * 
****************************************************************

1) put the table in append mode using the APPEND ON option of 
the ALTER TABLE command. 
or 2) db2set DB2MAXFSCRSEARCH=1 db2stop/db2start.

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

The problem is first fixed in DB2 version 10.1.0.4.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC97639 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

06.08.2013
23.01.2015
23.01.2015