|
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
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 |
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) |
