Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT04632 Status: Closed

DB2 V10.5 INSTANCE MAY TRAP WITH SIGNAL#11 in cdeAddCacheStats on MPP when
INTRA_PARALLEL is ENABLED.

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
DB2 V10.5 instance can trap with Signal#11 with following stack 
trace when running MPP and SMP (INTRA_PARALLEL YES) 
 
x090000000EF81474 lockMutex__Q3_7ibm_cde8services5MutexFPCci + 
0x34 
0x090000000F6AA230 
AddSubPoolSetStats__Q3_7ibm_cde5query22QuerySubPoolSetManagerFPQ 
3_7ibm_cde5query19PerThreadSubPoolSet + 0x50 
0x09000000106362CC 
cdeAddCacheStats__12cdeInterfaceFPQ3_7ibm_cde5query22QuerySubPoo 
lSetManager + 0xEC 
0x09000000106372CC cdeCleanupAgentCache__12cdeInterfaceFv + 
0x84C 
0x090000000A00BA60 
sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xD79C 
0x0900000009FB6F24 
sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xD10 
0x0900000009FB7978 @81@sqleSubRequestRouter__FP8sqeAgentPUiPUl + 
0x230 
0x0900000009A24C08 RunEDU__8sqeAgentFv + 0x2F068 
0x09000000099BC71C RunEDU__8sqeAgentFv + 0x124 
0x09000000092BCCD8 EDUDriver__9sqzEDUObjFv + 0x124 
0x09000000099AA4A8 sqloEDUEntry + 0x390
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL USERS OF DB2 LUW V10.5                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW V10.5 Fix Pack 5 or Later                 * 
****************************************************************
Local Fix:
turn INTRA_PARALLEL OFF
Solution
First Fixed in DB2 LUW V10.5 Fix Pack 5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
26.09.2014
22.12.2014
22.12.2014
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.5 FixList