home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 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 FixList
10.5.0.1 FixList