DB2 - Problem description
Problem IT36027 | Status: Closed |
IMPROVEMENTS TO CDE JOIN MEMORY USAGE. REDUCTION OF MEMORY NEEDED AND REDUCTION OF -955 ERRORS. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
IMPROVEMENTS TO CDE JOIN MEMORY USAGE. REDUCTION OF MEMORY NEEDED FROM SORTHEAP AND REDUCTION OF -955 ERRORS WHEN CDE JOIN HAS WIDE PAYLOAD. memory diagnostic will show a high shsorth memory allocation with high memory allocations coming from CompactHT.cpp file. Stack for memory allocation will have CHTExtraPayloadPage::CHTExtraPayloadPage constructor at the top. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * CDE JOIN QUERIES THAT REQUIRE A LOT OF MEMORY * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * See Error Description * **************************************************************** | |
Local Fix: | |
N/A | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * CDE JOIN QUERIES THAT REQUIRE A LOT OF MEMORY * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * See Error Description * **************************************************************** | |
Comment | |
See Error Description | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.02.2021 29.03.2021 06.04.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |