DB2 - Problem description
Problem IT29344 | Status: Closed |
MEMORY CORRUPTION / TRAP IN ALLOCMEM TERMFASTALLOC DURING COLUMNAR DATA PROCESSING | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
During re-execution of a statement processing columnar data, a cached invalid pointer is accessed resulting in memory corruption. The overwritten memory is often memory allocation metadata, resulting in traps while allocating or freeing memory. Trapping functions may vary widely, but the most common functions are : allocMem / sqloFastThreadAllocator::allocMem termFastAlloc / sqloFastThreadAllocator::termFastAlloc | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * **************************************************************** | |
Local Fix: | |
db2set -im DB2_REDUCED_OPTIMIZATION="COL_IXSCAN_ALL_V1133 OFF" db2 connect to db2 flush package cache dynamic - the "flush" is required to invalidate vulnerable cached SQL execution plans | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.06.2019 20.01.2020 20.01.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |