Symptom
- An error occurred during the upgrade process in the DB2 Database.
- The error message "SQL0954C Not enough storage is available in the application heap to process the statement. SQLSTATE=57011" was encountered.
- The issue is related to insufficient storage in the application heap during the database upgrade process.
Similar messages will output to the db2diag.log in /db2/db2<sid>/db2dump directory.
FUNCTION: DB2 UDB, catalog migration, sqlrlm_catalog_migrate, probe:2442
MESSAGE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH
"No memory available in 'Application Heap'"
DIA8301C No memory available in the application heap.
CALLED : DB2 UDB, catalog migration, sqlrlmLogErr
RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH
"No memory available in 'Application Heap'"
DIA8301C No memory available in the application heap.
DATA #1 : String with size, 50 bytes
Migration DMS rc=8b0f0001: Parallel upgrade errorFUNCTION: DB2 UDB, base sys utilities, sqlefmig, probe:20
MESSAGE : ZRC=0xFFFFFC46=-954
SQL0954C Not enough storage is available in the application heap to
process the statement.DATA #1 : <preformatted>
Node: 0 is a catalog node. Catalog migration failed
Read more...
Environment
DB2 Universal Database for Unix / NT
Db2 LUW IBM
BC-DB-DB6-UPG
Product
Keywords
DB2 Database, Upgrade Error, Insufficient Storage, Application Heap, SQL0954C, SQLSTATE=57011, SAP ERP, Database Administration, Restore & Recovery. , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview