Unanswered: No memory available in the application heap
On DB2 V7.2 fp5 on Windows 2000 in db2diag.log the following message is constantly written: "No memory available in the application heap".
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.
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?
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.