I'm on DB2 V9.1. I got an "Out of memory failure" in the db2diag.log. Not sure what it all means and what could have caused this and what do about it. Here is the full log:


2010-03-08-12.00.51.032573-360 E1395217A706 LEVEL: Warning
PID : 5169284 TID : 1 PROC : db2agent (PSFT811) 0
INSTANCE: db2inst1 NODE : 000 DB : PSFT811
APPHDL : 0-1763 APPID: GA6400AB.M210.119A88175900
AUTHID : E1USER
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
DATA #1 : <preformatted>
Out of memory failure for Shared Sort Heap (SHEAPTHRES_SHR) on node 0.
Requested block size : 41825376 bytes.
Physical heap size : 375193600 bytes.
Configured heap size : 906231808 bytes.
Unreserved memory used by heap : 0 bytes.
Unreserved memory left in set : 514326528 bytes.



2010-03-08-12.00.51.278659-360 I1395924A456 LEVEL: Event
PID : 6086816 TID : 1 PROC : db2agent (PSFT811) 0
INSTANCE: db2inst1 NODE : 000 DB : PSFT811
APPHDL : 0-2282 APPID: 10.100.0.152.65490.100308180121
AUTHID : E1USER
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : STMM CFG DB PSFT811: "Sortheap" From: "17131" <automatic> To: "11139" <automatic>


Has anyone encounter this issue and what did you do to fix this problem?
Thank you.


CC

What flavor of DB2 (Workgroup, Enterprise, Express-C) are you using?

What OS?

What is the DBM config"

What is the DB config?

How much memory (RAM) does the server have?

Is it 32 or 64 bit?

Andy