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