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 IC97714 Status: Closed

MONITOR ROUTINE ALLOCATIONS FAIL WITH SQL0954

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
Large monitor routine allocations (eg. from 
MON_GET_PKG_CACHE_STMT) should not be allocated from application 
heap as the Application shared memory area was not designed for 
the single large temporary requirements.  They will be moved to 
private memory which is more dynamic in terms of virtual 
allocations (private memory can be "unmapped") and no longer 
under control of Application Heap size (APPLHEAPSZ).
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All systems, especially systems running OPM                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 4                       * 
****************************************************************
Local Fix:
Change APPLHEAPSZ to the default AUTOMATIC, or increase the 
fixed limit, or increase Instance Memory limit.  When using the 
MON_GET_PKG_CACHE_STMT routine it is advised to use filtering to 
reduce memory allocation requirements.
available fix packs:
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Solution
Problem first fixed in DB2 Version 10.1 Fix Pack 4
Workaround
see Local Fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
15.11.2013
16.06.2014
16.06.2014
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.4 FixList
10.5.0.4 FixList