Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC84503 Status: Geschlossen

OUT OF APPLICATION HEAP MEMORY IN CLI LOAD CAN CAUSE INSTANCE ABEND

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
When available application heap is exhausted the following error 
will show in the db2diag.log : 
 
FUNCTION: DB2 UDB, SQO Memory Management, 
sqloMemLogPoolConditions, probe:30 
DATA #1 : <preformatted> 
Out of memory failure for Application Heap (APPLHEAPSZ) on node 
0. 
 
If the out of application heap memory error was triggered by  a 
CLI Load operation, then that may lead to the instance 
shutting down unexpectedly. 
 
The db2diag.log may show : 
 
 
2012-01-20-10.08.16.759655+060 I31207488A454      LEVEL: Severe 
PID     : 1961                 TID  : 246         PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000         DB   : SAMPLE 
APPHDL  : 0-1688               APPID: *N0.db2inst1.120120090440 
AUTHID  : DB2INST1 
EDUID   : 246                  EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, database utilities, sqlu_register_table_load, 
probe:1101 
MESSAGE : Load Error: Error loading partitions. 
 
2012-01-20-10.08.16.777874+060 I31207943A1988     LEVEL: Severe 
PID     : 1961                 TID  : 246         PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000         DB   : SAMPLE 
APPHDL  : 0-1688               APPID: *N0.db2inst1.120120090440 
AUTHID  : DB2INST1 
EDUID   : 246                  EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, SQO Memory Management, 
sqloDiagnoseFreeBlockFailure, probe:10 
MESSAGE : Possible memory corruption detected. 
 
A stack trace will show the following functions : 
 
 
sqloMemSearchForChunkSubgroupHeadermb 
sqlofmblkEx 
sqljsDrdaAsCBCompletionArrayInput 
sqlrr_array_input_load_cleanup 
sqlrr_array_input_load 
sqljs_ddm_excsqlstt 
sqljsParseRdbAccessed 
sqljsParse 
sqleSetWlmAgentEvent 
sqmPackageListManager::cleanupPackageList
Problem-Zusammenfassung:
See problem description
Local-Fix:
Configure the application heap size to an automatic setting in 
order to avoid the out of memory condition
verfügbare FixPacks:
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

Lösung
This apar was first fixed in V10 Fix Pack 1
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
14.06.2012
11.01.2013
11.01.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.1 FixList
10.5.0.1 FixList