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...

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.

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?

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.

Chavadb2:

Ok. thanks. I'll try it.