DB2 - Problem description
Problem IC84322 | Status: Closed |
DB2 INSTANCE MAY ABEND IN SQLRISECTINITXMLERROREXIT IF DATABASE APPLHEAPSZ IS EXHAUSTED | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
DB2 instance may crash in sqlriSectInitXMLErrorExit with NULL pointer region being freed, with the stack similar to: 0 sqloCrashOnCriticalMemoryValidationFailure 1 sqloCrashOnCriticalMemoryValidationFailure@glue6FC 2 sqlofmblkEx 3 sqlriSectInitXMLErrorExit 4 sqlriSectInitializeComplex when the following is true: Database is out of application heap size and the message that database is out APPLHEAPSZ is observed before crash, like 2011-00-00-00:00:00 0 LEVEL: Warning PID : 12345678 TID : 123445 PROC : db2sysc 0 INSTANCE: xxxxxxxx NODE : 000 DB : XXXXXX APPHDL : 0-XXXX APPID: X.X.X.X AUTHID : XXXXX EDUID : 123456 EDUNAME: db2agent (XXXX) 0 FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30 DATA #1 : <preformatted> Out of memory failure for Application Heap (APPLHEAPSZ) on node 0. Requested block size : 4376 bytes. Physical heap size : 8388608 bytes. Configured heap size : 8388608 bytes. Unreserved memory used by heap : 0 bytes. Unreserved memory left in set : 0 bytes. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All DB2 V10.1 Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V10.1 Fix Pack 1 or higher. * **************************************************************** | |
Local Fix: | |
Increase APPLHEAPSZ database parameter | |
available fix packs: | |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows | |
Solution | |
Fixed in DB2 V10.1 Fix Pack 1 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.06.2012 02.09.2014 02.09.2014 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.1 | |
10.5.0.1 |