home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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