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 |