Results 1 to 9 of 9
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: No memory available in the application heap

    Hi,

    On DB2 V7.2 fp5 on Windows 2000 in db2diag.log the following message is constantly written: "No memory available in the application heap".

    See details:
    Code:
    2004-06-14-12.11.07.568000   Instance:DB2   Node:000
    PID:824(db2syscs.exe)   TID:4500   Appid:C0A80524.9B07.040614101103
    access_plan_manager  sqlra_load_var   Probe:20   Database:DATABASE1
    DIA3601C No memory available in the application heap.

    I have executed the following command: "db2 get db cfg for database1 | find "APPLHEAPSZ". See the result.

    Code:
     Default application heap (4KB)             (APPLHEAPSZ) = 128
    I should probably increase the APPLHEAPSZ. What should new value be? Do I need to increase any other parameter?

    Thanks,
    Grofaty
    Last edited by grofaty; 06-18-04 at 08:05.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I would make it 512 ..

    AFAIK, you do not need to adjust any other parm

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    May 2004
    Posts
    4
    Grofaty,

    the common way is to double it. if it is still not enough then double it again.
    Another good way is to look at the application which is causing the error. In your case application C0A80524.9B07.040614101103. You can use the first part to obtain the ip adress (C0=192,A8=168,05=5,24=36) of the application or use snapshots to get more information about it.
    Sometimes it is because there are still "open" result sets in the application.

    cheers
    fynn

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    Thank you all folks.

    fynn00, one more question. What is the meaning of complete set "C0A80524.9B07.040614101103?"

    Ok, first string C0A80524 is IP address represented in hexadecimal value.
    What is the meaning of other two strings: 9B07.040614101103

    Thanks,
    Grofaty

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    9b07 - client port
    040614101103 - Timestamp in CUT (yymmddhhmmss) - connection timestamp
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  6. #6
    Join Date
    Jan 2003
    Posts
    1,605
    Thank you sathyaram_s,

    Is client port in hexadecimal?
    So the 9b07 is port number: 39687?

    Thanks,
    Grofaty

  7. #7
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    yes .. it is in hex
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  8. #8
    Join Date
    Mar 2004
    Posts
    448
    if you run

    get snapshot for all <db_name>|grep -i "rejected block cursor requests"

    compare this value to the no of requests for getting the results, then your aslheapsz is small.

    regards,

    mujeeb

  9. #9
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    Thanks to you all. Nice tips!

    Grofaty

Posting Permissions

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