|
Problem IC99489
|
Status: Geschlossen |
SQL20442 ERROR ATTEMPTING TO ALLOCATE APPLICATION HEAP MEMORY FOR ARRAY VALUES IN SQL PROCEDURES |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
When allocating memory from the application heap for array
values for SQL procedures, DB2 performs an available memory
check. This check is excessively conservative and results in
unnecessary SQL20442 errors. This check will be removed under
this APAR. If it desired to limit the amount of application
heap that can be allocated for this purpose, it is recommended
to test applications and determine an appropriate upper limit to
use as a fixed setting for the APPLHEAPSZ database configuration
parameter . |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* all systems *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 Fix Pack 4 *
**************************************************************** |
| Local-Fix: |
Determine an appropriate fixed APPLHEAPSZ setting, which
overrides any further checking of available Application Memory
(APPL_MEMORY), Instance Memory (INSTANCE_MEMORY), or system
memory |
| verfügbare FixPacks: |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Lösung |
Problem first fixed in DB2 Version 10.5 Fix pack 4 |
| Workaround |
see Local Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 19.02.2014
22.09.2014
22.09.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.4
|
 |
