SAP Knowledge Base Article - Preview

3522277 - DB6: Database Upgrade Error DIA8301C with SQL0954C

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 error

    FUNCTION: 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

SAP ERP all versions

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.