DB2 - Problem description
Problem IT22284 | Status: Closed |
APPLICATION HEAP CAN BE EXHAUSTED BY REBAL FUNCTION AND THIS CANLEAD TO APPLICATION FAILURE WITH OUT OF MEMORY | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
On a database running with INTRA_PARALLEL=YES and DEGREE higher than 1, if application is failing with out of memory and following command db2pd -alldbs -memblocks appl | grep -A 10 "All memory cons" shows that one allocation is taking entire application heap: All memory consumers in Application memory set: PoolAddr PoolID PoolName SecondID TotalSize(Bytes) %Bytes TotalCount %Count LOC File 0x00007FEAEB958CE8 1 apph 15638 7619892696 89.43 879489 0.29 1102 1984253944 where 7619892696 is the size of entire application heap. Plan that is taking all this memory has REBAL operator and above allocation is coming from REBAL code. This fix is needed to control memory consumed by REBAL | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 version 111m3fp3 * **************************************************************** | |
Local Fix: | |
db2set DB2_COMPILER_SMP_OVERRIDES=1 (requires instance recycle) | |
available fix packs: | |
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
APPLICATION HEAP CAN BE EXHAUSTED BY REBAL FUNCTION AND THIS CAN LEAD TO APPLICATION FAILURE WITH OUT OF MEMORY | |
Workaround | |
see Local Fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.09.2017 15.03.2018 16.08.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |