Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2008
    Posts
    40

    Unanswered: No memory available in 'Application Heap

    Hi All,
    I faced this issue in by db No memory available in 'Application Heap, What is the reason of such an issue , currently my application heap size is 1024 , i dont want to blindly double it , i want to find out what could cause to exhaust its limit...

    iam running DB2 v8.1.1.89 fix pack9 on a 32 bit instance

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you double it, you will only be adding 4MB of memory. I would recommend that you double it to 2048 pages.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jun 2008
    Posts
    40
    Quote Originally Posted by Marcus_A
    If you double it, you will only be adding 4MB of memory. I would recommend that you double it to 2048 pages.
    Thanks for the reply Markus ...
    but can you throw some light on why this occurs because the same works in another environment and its little hard to convince people with it.

    also I checked only couple of connections/ result sets were open and that would be closed. but any sql part which i can tune or my sql are missing any thing ????

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    What are the SQL statements (and other database operations) that you are running?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I have found that most Java applications need 2048 or higher.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Jun 2008
    Posts
    40
    Quote Originally Posted by stolze
    What are the SQL statements (and other database operations) that you are running?
    Thanks for the reply...

    lot of sql statements its majorly a reporting env ,

  7. #7
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Well, then you have to reconfigure something or other to fix this issue.

    (Sorry for the sarcasm, but I tried to be as specific as you are.)
    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
  •