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 IC69691 Status: Geschlossen

ERROR SQL0954C DOING CLI LOAD OF LOB OR LONG COLUMNS BECAUSE OF HIGH
APPLICATION HEAP MEMORY USAGE.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When doing a CLI LOAD of columns of LONG or LOB data types, 
application heap memory usage grows so that you might get error: 
 SQL0954C Not enough storage is available in the application 
heap to process the statement. 
 
If you get the error, db2diag.log contains an entry like this: 
 
 9999-12-31-00.00.00.000000+000 XXXXXXXXXXXX       LEVEL: Severe 
 PID     : XXXXX                TID  : XXXXXXXXXXXXXXXX : 
db2agent (XXXXXXXX) 0 
 INSTANCE: XXXXXXXX             NODE : 000         DB 
:XXXXXXXX 
 APPHDL  : XXXXX 
APPID:XXXXXXXXXXXXXXXXXXXXXXXXXX 
 AUTHID  : XXXXXXXX 
 FUNCTION: DB2 UDB, relation data serv, sqlrr_array_input_load, 
probe:95 
 RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH 
           "No memory available in 'Application Heap'" 
           DIA8301C No memory available in the application heap.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of DB2 for Linux, UNIX and Windows with applications   * 
* that use CLI (Call Level Interface)                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* .                                                            * 
****************************************************************
Local-Fix:
As a workaround, set the database configuration parameter 
APPLHEAPSZ to AUTOMATIC or increase its value.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in Version 9.7 Fix Pack 4
Workaround
As a workaround, set the database configuration parameter 
 
APPLHEAPSZ to AUTOMATIC or increase its value.
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
05.07.2010
24.05.2011
24.05.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP4
Problem behoben lt. FixList in der Version
9.7.0.4 FixList