DB2 - Problembeschreibung
Problem IC97714 | Status: Geschlossen |
MONITOR ROUTINE ALLOCATIONS FAIL WITH SQL0954 | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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. | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
Problem first fixed in DB2 Version 10.1 Fix Pack 4 | |
Workaround | |
see Local Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 15.11.2013 16.06.2014 16.06.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.4 | |
10.5.0.4 |