|
Problem IC99489
|
Status: Closed |
SQL20442 ERROR ATTEMPTING TO ALLOCATE APPLICATION HEAP MEMORY FOR ARRAY VALUES IN SQL PROCEDURES |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 |
| available fix packs: |
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
|
| Solution |
Problem first fixed in DB2 Version 10.5 Fix pack 4 |
| Workaround |
see Local Fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.02.2014
22.09.2014
22.09.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
