Unanswered: Question about application support layer heap size
We use db2 8.2.6 on windows
We get following error in our prod env (frequency roughly 1 in 2-3 weeks).
The Application Support Layer heap cannot be allocated. SQLSTATE=57011
Initially the applheapsz for the instance was 1280 (4K pages). We increased it to 2560, but still getting this error.
The error affects only 2 of our applications. These use fderated access to tables from another database running in the same same instance. Other applications (mainly online apps) continue to work OK after this error.
Any idea what is causing this error. will it help if we raise the applheapsize further. Why applheapsize exceed error only occurs with the 2 apps that use federated access to another database running within same instance?
The extract from db2diag is as follows....
2008-09-11-188.8.131.528000+600 E309767H566 LEVEL: Error (OS)
PID : 5344 TID : 5304 PROC : db2syscs.exe
INSTANCE: AXISPROD NODE : 000
FUNCTION: DB2 UDB, SQO Memory Management, sqlogmshr3, probe:100
CALLED : OS, -, MapViewOfFileEx
OSERR : 8 "Not enough storage is available to process this command."
DATA #1 : Memory set type, PD_TYPE_SET_TYPE, 4 bytes
DATA #2 : Actual allocated set size, PD_TYPE_REAL_SET_SIZE, 4 bytes
DATA #3 : Memory set address, PD_TYPE_SET_ADDRESS, 4 bytes
I typed it wrong. please read it as 'aslheapsz' instead od applheapsz.
We increased aslheapsz from 1280 pages to 2560 pagesand is still getting the above mentioned error.
Any idea what is causing this error. will it help if we raise the aslheapsize further. Why aslheapsize exceed error only occurs with the 2 apps that use federated access to another database running within same instance?
Look at the error closely. It is saying that it cannot allocate the asl heap, not that it is too small. It looks like you are running out of memory.
SQL1221N The Application Support Layer heap cannot be
The Application Support Layer heap could not be allocated. The
cause of this error may be insufficient memory resources either
for the database manager or the environment in which its
operations are being attempted. Memory resources that can cause
this error include:
o The number of shared memory identifiers allocated in the
o The amount of paging or swapping space available in the
o The amount of physical memory available in the system
One or more of the following:
o Validate that sufficient memory resources are available to
satisfy the database manager's requirements, and those of the
other programs running on the system.
o Reduce the aslheapsz configuration parameter.
o Where appropriate, stop other programs using the system.