Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2007
    Posts
    2

    Unanswered: Out of mermory failure for application heap.

    Hi,

    I have recently upgraded my database from db2 V8 to db2 v9 fix pack 5.
    I getting following error in db2daig.log file and instance will be shutdown automatically.

    Funcation: DB@ UDB, SQO Memory management, sqlomemlogpoolconditions, Probe:30
    Data #2:<Preformatted>
    Out of mermory failure for application heap.
    Requested block size: 688 bytes
    physical heap size:65536 bytes
    configured heap size: 1310851072 bytes

    Can anyone please help me how to fix this problem.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Reduce the heap size for the application heap from 1.3GB to something reasonable.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Jul 2007
    Posts
    2
    Thanks for quick response.

    please find the configuration parameters set in server.

    APPLHEAPSZ=10000(4KB)
    STMTHEAPSZ=16000(KB)
    APP_CTL_HEAP_SZ=1024
    GROUPHEAP_RATIO=70
    APPLGROUP_MEM_SZ=20000(KB)
    UTIL_HEAP_SZ=10240(KB)

    But what the application heap in the above, how to find the application heap in my server.

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    How exactly did you determine the config parameters? I am asking because you reformatted them, and maybe you have STMM running or so. Seeing the exact output of the command (including the SHOW DETAILS option) on the console/shell would be appreciated.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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