There is not enough memory available now

[elza]

Hi ,

LEVEL: Severe (OS)
PID : 389298 TID : 1 PROC : db2agent (test) 0
INSTANCE: db2inst1 NODE : 000 DB : TEST
APPHDL : 0-998 APPID: G97E4C3B.FEAD.071025211830
FUNCTION: DB2 UDB, oper system services, getPrivateChunksFromOs, probe:100
CALLED : OS, -, malloc
OSERR : ENOMEM (12) "There is not enough memory available now."
MESSAGE : Private memory and/or virtual address space exhausted
DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
274518016

I am getting this error in the db2diag.log.can anyone help me on this....

[l***@ca.ibm.com]

Hello,

Is this on a 32-bit instance, or 64-bit? And which OS and release of DB2 are you using?

As a wild guess, I would assume this was likely a memory request for a large private sort. You should check your sortheap config parameter, and ensure that the data ulimit for the instance owner is set appropriately.

Cheers,
Liam.

[elza]

Thanks I got resolved this issue by reducing the sortheap parameter size