No memory available in the application heap

grofaty · #1 (**permalink**) 06-14-04, 07:55

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

sathyaram_s · #2 (**permalink**) 06-14-04, 08:12

I would make it 512 ..

AFAIK, you do not need to adjust any other parm

Cheers
Sathyaram

fynn00 · #3 (**permalink**) 06-14-04, 09:47

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

grofaty · #4 (**permalink**) 06-15-04, 04:28

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

sathyaram_s · #5 (**permalink**) 06-15-04, 04:31

9b07 - client port
040614101103 - Timestamp in CUT (yymmddhhmmss) - connection timestamp

grofaty · #6 (**permalink**) 06-15-04, 05:22

Thank you sathyaram_s,

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

Thanks,
Grofaty

sathyaram_s · #7 (**permalink**) 06-15-04, 11:40

yes .. it is in hex

bmujeeb · #8 (**permalink**) 06-15-04, 11:53

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

grofaty · #9 (**permalink**) 06-18-04, 01:30

Hi,

Thanks to you all. Nice tips!

Grofaty

Internet Services

Web Development

Digital Marketing

Consumer Tech