Results 1 to 5 of 5
  1. #1
    Join Date
    May 2004
    Posts
    25

    Unanswered: No memory available in the application heap

    Hi everybody:
    My env. is Windows 2000 Server and DB2 V8.1 ESE.
    Sometimes I get the following error when performing a
    query report. (db2diag.log entry)

    2005-01-10-16.45.21.187003 InstanceB2 Node:000
    PID:400(db2syscs.exe) TID:3092 Appid:*LOCAL.DB2.01C600194436
    access plan manager sqlra_sqlW_mem_get_block Probe:9999 DatabaseBSAR
    DIA8301C No memory available in the application heap.

    I have read on IBM website that three DB Params have to do something with it. "Application heap size", "Sort heap size" and "Statement heap size". (this is what I understood, may be I'm wrong)

    My questions:
    1) Are all these 3 param related to this error?
    2) Which one should I increase.?
    3) Is there another param or value that I should check or change , instead/besides?

    Thanks...

  2. #2
    Join Date
    Aug 2004
    Posts
    138
    take a snapshot and see the high water mark for the application heap and increase according to that. You can tune the sortheap and statement heap too by looking at the high water marks. In your case , application heap tuning is enough I think.

  3. #3
    Join Date
    May 2004
    Posts
    25
    Chavadb2:
    I have taken a snapshot this way: "get snapshot for applications on dbres;".
    And I see only two params: applheapsz and app_ctl_heap_sz. For both i see three values:
    - Actual Size (bytes)
    - Limit mark (bytes)
    - Max. allowed size (bytes)
    Values of "Actual size" and "Limit mark" are equal.

    My questions:
    - Do I need to execute a different option in "get snapshot" for getting watermarks.
    - If problem happened let's say 2 hours ago. is it useful to me a current snapshot?

  4. #4
    Join Date
    Aug 2004
    Posts
    138
    I guess here high water mark = limit mark.. better to reset monitors first..and reproduce the problem and take a snapshot.if the limit mark reaches Max. allowed size (bytes), you need to increase that parameter.

  5. #5
    Join Date
    May 2004
    Posts
    25
    Chavadb2:

    Ok. thanks. I'll try it.

Posting Permissions

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