DB2 - Problem description
Problem IT37270 | Status: Closed |
CREATE TABLE FAILING WITH "NO MEMORY AVAILABLE IN 'APPLICATION HEAP' | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Out of memory failure for Application Heap (APPLHEAPSZ) And -973 for utility heap Running following create table statement create table U360384.QRM_CM_MASTER_MR as ( select * from SDSNZA01_BDW.QRM_CM_MASTER_MR ) WITH DATA NOT LOGGED INITIALLY ; ) 2020-03-31-23.01.31.499176+000 E25185285E818 LEVEL: Warning PID : 130466 TID : 47868580718336 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : BLUDB APPHDL : 0-55969 APPID: *N0.db2inst1.200331230134 UOWID : 1 ACTID: 1 AUTHID : DB2INST1 HOSTNAME: dashmpp-head-0 EDUID : 31428 EDUNAME: db2agent (BLUDB) 0 FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30 DATA #1 : Out of memory failure for Application Heap (APPLHEAPSZ) on node 0. Requested block size : 145920 bytes. Physical heap size : 196608 bytes. Configured heap size : 1048576 bytes. Unreserved memory used by heap : 0 bytes. Unreserved memory left in set : 0 bytes. 2020-03-31-23.01.31.554685+000 I25186104E725 LEVEL: Severe PID : 130466 TID : 47868580718336 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : BLUDB APPHDL : 0-55969 APPID: *N0.db2inst1.200331230134 UOWID : 1 ACTID: 1 AUTHID : DB2INST1 HOSTNAME: dashmpp-head-0 EDUID : 31428 EDUNAME: db2agent (BLUDB) 0 FUNCTION: DB2 UDB, WLM, sqlrwGetWLMTableFunctionMergedResult, probe:50 CALLED : DB2 UDB, WLM, sqlrwGetWLMTableFunctionMergedResult RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH "No memory available in 'Application Heap'" DIA8301C No memory available in the application heap. The histogram building phase of dictionary creation consumed too much memory which caused the No Memory in Application Heap? | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * fixed in db2_v115m5fp0 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * fixed in db2_v115m5fp0 * **************************************************************** | |
Comment | |
fixed in db2_v115m5fp0 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 15.06.2021 01.07.2021 01.07.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |