DB2 - Problem description
Problem IT28228 | Status: Closed |
DB2 MAY ABEND ON A QUERY THAT CONTAINS A COLUMNAR FETCH-INDEX SCAN THAT RUNS OUT OF APPLICATION HEAP | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
On a plan that contains a columnar fetch-index scan, db2 can abend if the instance runs out of application heap with this stack: 4 sqloEDUCodeTrapHandler 5 __restore_rt 6 cdeInterface::isColumnHot 7 sqlriCdeFFVPrefetchPages 8 sqlriCdeFastFetchVector | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all, serial and dpf * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * install latest fixpack * **************************************************************** | |
Local Fix: | |
apply latest fixpack or: db2set -im DB2_REDUCED_OPTIMIZATION="COL_IXSCAN_ALL_V1133 OFF" at the cost of performance for certain queries | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 26.02.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) |