Hi ,


Load is failing on a production server with the following errors. I believe the private memory is getting exhausted. Tweaking with the memory on production database is not a feasible solution as it is a highly visible application.Please provide your tips to get is resolved

2007-08-08-02.05.24.905038-240 E17397318A548 LEVEL: Severe (OS)
PID : 13741 TID : 2199083744640PROC : db2lrid 0
INSTANCE: db2inst1 NODE : 000 DB : MARKETDB
APPHDL : 0-311 APPID: AC188950.B8C2.0155C8060434
FUNCTION: DB2 UDB, oper system services, getPrivateChunksFromOs, probe:100
CALLED : OS, -, malloc
OSERR : ENOMEM (12) "Cannot allocate memory"
MESSAGE : Private memory and/or virtual address space exhausted
DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
1445888

2007-08-08-02.05.24.905101-240 I17397867A506 LEVEL: Warning
PID : 13741 TID : 2199083744640PROC : db2lrid 0
INSTANCE: db2inst1 NODE : 000 DB : MARKETDB
APPHDL : 0-311 APPID: AC188950.B8C2.0155C8060434
FUNCTION: DB2 UDB, sort/list services, sqlsAllocateSortMemory, probe:35
DATA #1 : <preformatted>
Not enough memory available for a (private) sort heap of size 1000
bufSize = 1429504, bPrivatePool = 1, bPoolHasSpace = 1
Trying smaller size...

2007-08-08-02.05.24.905180-240 E17398374A548 LEVEL: Severe (OS)
PID : 13741 TID : 2199083744640PROC : db2lrid 0
INSTANCE: db2inst1 NODE : 000 DB : MARKETDB
APPHDL : 0-311 APPID: AC188950.B8C2.0155C8060434
FUNCTION: DB2 UDB, oper system services, getPrivateChunksFromOs, probe:100
CALLED : OS, -, malloc
OSERR : ENOMEM (12) "Cannot allocate memory"
MESSAGE : Private memory and/or virtual address space exhausted
DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
1347584

2007-08-08-02.05.24.905261-240 E17398923A548 LEVEL: Severe (OS)
PID : 13741 TID : 2199083744640PROC : db2lrid 0
--More--

What is your OS??.If it is AIX,change the ulimit(memory) parameter value to 'unlimited'.

--Naga

My OS is linux. The ulimit data seg is set to unlimited already. Is there any other thing i can check for??

Can you provide more info? db2 version, Linux version, hardware details (including memory), is db2 hosted independently on the box?

Can you also provide the output of:
get dbm cfg and get db cfg?

Also, details of buffer pools.