Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2014
    Posts
    14

    Unanswered: DIA8301C No memory available in the application heap.

    Since last night we have been seeing the below error in the log file. I'm unable to get sessions from db2top, I get the below error.

    For DB2TOP

    SQL1042C An unexpected system error occurred. SQLSTATE=58004

    Diaglog entry

    2014-03-31-15.45.14.002226-420 I101241E597 LEVEL: Warning
    PID : 10383 TID : 139777789650688 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : DB2O
    APPHDL : 0-9544 APPID: 192.168.99.9.33870.140331224513
    AUTHID : CLEADMN2 HOSTNAME: tprccmfadb002.rcc.gapinc.dev
    EDUID : 36211 EDUNAME: db2agent (DB2OLUW) 0
    FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:15
    DATA #1 : <preformatted>
    DB-DB2O - Current size : 209000000 KB, HWM : 209000000 KB, Reserved : 0 KB

    2014-03-31-15.45.14.002463-420 I101839E616 LEVEL: Warning
    PID : 10383 TID : 139777789650688 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : DB2O
    APPHDL : 0-9544 APPID: 192.168.99.9.33870.140331224513
    AUTHID : CLEADMN2 HOSTNAME: tprccmfadb002.rcc.gapinc.dev
    EDUID : 36211 EDUNAME: db2agent (DB2OLUW) 0
    FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:16
    DATA #1 : <preformatted>
    Aggregated stats for 2 Local Applications Sets
    Current size : 512 KB
    HWM : 512 KB
    Reserved : 0 KB

    2014-03-31-15.45.14.002727-420 E102456E800 LEVEL: Warning
    PID : 10383 TID : 139777789650688 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : DB2O
    APPHDL : 0-9544 APPID: 192.168.99.9.33870.140331224513
    AUTHID : CLEADMN2 HOSTNAME: tprccmfadb002.rcc.gapinc.dev
    EDUID : 36211 EDUNAME: db2agent (DB2OLUW) 0
    FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
    DATA #1 : <preformatted>
    Out of memory failure for Application Heap (APPLHEAPSZ) on node 0.
    Requested block size : 1541128 bytes.
    Physical heap size : 917504 bytes.
    Configured heap size : 1048576 bytes.
    Unreserved memory used by heap : 0 bytes.
    Unreserved memory left in set : 0 bytes.

    2014-03-31-15.45.14.002971-420 I103257E707 LEVEL: Error
    PID : 10383 TID : 139777789650688 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : DB2O
    APPHDL : 0-9544 APPID: 192.168.99.9.33870.140331224513
    AUTHID : CLEADMN2 HOSTNAME: tprccmfadb002.rcc.gapinc.dev
    EDUID : 36211 EDUNAME: db2agent (DB2OLUW) 0
    FUNCTION: DB2 UDB, WLM, sqlrwExpandableBuffer::getNextElement, probe:10
    CALLED : DB2 UDB, WLM, sqlrwExpandableBuffer::getNextElement
    RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH
    "No memory available in 'Application Heap'"
    DIA8301C No memory available in the application heap.

    2014-03-31-15.45.14.003338-420 I103965E646 LEVEL: Error
    PID : 10383 TID : 139777789650688 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : DB2O
    APPHDL : 0-9544 APPID: 192.168.99.9.33870.140331224513
    AUTHID : CLEADMN2 HOSTNAME: tprccmfadb002.rcc.gapinc.dev
    EDUID : 36211 EDUNAME: db2agent (DB2OLUW) 0
    FUNCTION: DB2 UDB, WLM, sqlrwTablespaceMetricsBuilder::execute, probe:10
    RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH
    "No memory available in 'Application Heap'"
    DIA8301C No memory available in the application heap.

  2. #2
    Join Date
    Mar 2014
    Posts
    14
    db2 get dbm cfg | grep heap

    Database monitor heap size (4KB) (MON_HEAP_SZ) = AUTOMATIC(0)
    Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048
    Sort heap threshold (4KB) (SHEAPTHRES) = 0
    Application support layer heap size (4KB) (ASLHEAPSZ) = 30



    db2 get db cfg | grep heap
    Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC(1880680)
    Sort list heap (4KB) (SORTHEAP) = AUTOMATIC(50000)
    Database heap (4KB) (DBHEAP) = AUTOMATIC(900)
    Utilities heap size (4KB) (UTIL_HEAP_SZ) = AUTOMATIC(478646)
    SQL statement heap (4KB) (STMTHEAP) = AUTOMATIC(8192)
    Default application heap (4KB) (APPLHEAPSZ) = AUTOMATIC(256)
    Statistics heap size (4KB) (STAT_HEAP_SZ) = AUTOMATIC(4384)

  3. #3
    Join Date
    Mar 2014
    Posts
    14
    db2pd -dbptnmem

    Database Member 0 -- Active -- Up 6 days 02:50:20 -- Date 2014-03-31-16.17.02.153531

    Database Member Memory Controller Statistics

    Controller Automatic: N
    Memory Limit: 220000000 KB
    Current usage: 219998784 KB
    HWM usage: 220000896 KB
    Cached memory: 1024 KB

    Individual Memory Consumers:

    Name Mem Used (KB) HWM Used (KB) Cached (KB)
    ================================================== ======
    APPL-DB2O 61632 160000 896
    DBMS-db2inst1 221440 248512 128
    FMP_RESOURCES 22528 22528 0
    PRIVATE 10692672 10694784 0
    DB-DB2O 209000000 209000000 0
    LCL-p50985 256 256 0
    LCL-p39001 256 256 0

  4. #4
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Please, show the results of the following queries:
    Code:
    select db_name, application_handle, memory_pool_used, memory_pool_used_hwm
    from table(MON_GET_MEMORY_POOL('APPLICATION', current server, -1));
    
    select value * 4096
    from sysibmadm.dbcfg
    where name='appl_memory';
    Regards,
    Mark.

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Quote Originally Posted by db2_nube View Post
    db2pd -dbptnmem

    Database Member 0 -- Active -- Up 6 days 02:50:20 -- Date 2014-03-31-16.17.02.153531

    Database Member Memory Controller Statistics

    Controller Automatic: N
    Memory Limit: 220000000 KB
    Current usage: 219998784 KB
    HWM usage: 220000896 KB
    Cached memory: 1024 KB

    Individual Memory Consumers:

    Name Mem Used (KB) HWM Used (KB) Cached (KB)
    ================================================== ======
    APPL-DB2O 61632 160000 896
    DBMS-db2inst1 221440 248512 128
    FMP_RESOURCES 22528 22528 0
    PRIVATE 10692672 10694784 0
    DB-DB2O 209000000 209000000 0
    LCL-p50985 256 256 0
    LCL-p39001 256 256 0

    What's APPL_MEMORY set to for db? Did you set memory related parms (ie. bufferpools, dbm/db) manually or used some tool?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •