|
Problem IT23941
|
Status: Closed |
DB2 ABEND DUE TO MEMORY CORRUPTION USING COLUMN BASED TABLES |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
When queries are executed with a high degree of parallelism
while accessing column based tables, a rare timing hole may
result in memory corruption, causing DB2 to abend.
While the trapping function stack may vary, the most common
function stack observed is :
diagnoseMemoryCorruptionAndCrash__13SQLO_MEM_POOLFUlCPCcCb
sqloDiagnoseFreeBlockFailure__FP8SMemFBlkCb
sqlofmblkEx
freeMem__Q3_7ibm_cde8services4HeapFCPCcCUlPv
freeHeap__Q3_7ibm_cde8services15ManagedHeapBaseFv
__dt__Q3_7ibm_cde8services15ManagedHeapBaseFv
__dt__Q3_7ibm_cde8services11ManagedHeapXTUcSP0_Fv
__dt__Q3_7ibm_cde5query14QueryResourcesFv
__dt__Q3_7ibm_cde5query9SchedulerFv
cleanAndDeleteScheduler__Q3_7ibm_cde5query9SchedulerFPQ3_7ibm_cd
e5query9Scheduler |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* database servers processing column-based data *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 11.1 Mod 1 Fix Pack 1 *
**************************************************************** |
| Local Fix: |
reducing the maximum or default degree of parallelism will tend
to avoid the problem, eg. to 4 |
| available fix packs: |
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
Problem first fixed in DB2 Version 11.1 Mod 3 Fix Pack 3 |
| Workaround |
see Local Fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.02.2018
15.03.2018
04.06.2019 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
