Hello,
Please give me some guidence.
DB2 V8.2 on Windows 2003 Enterprise edition / 4GB (dual core) RAM.
We have been experiencing some memory shortage. because of this the health monitor is not starting, even db2pd is not working. This is the error in the diag.log.
-----------------------------------------------------------------------
2009-12-21-22.18.31.513000+000 I17837608H330 LEVEL: Error (OS)
PID : 6092 TID : 4164
FUNCTION: DB2 Common, OSSe, OSSHIPCMemory::attach, probe:70
MESSAGE : ECF=0x9000000D Insufficent memory
CALLED : OS, -, MapViewOfFileEx OSERR: ERROR_OUTOFMEMORY (8)
----------------------------------------------------------------------
Even the backup was failed with the follwoing error.
SQL1225N The request failed because an operating system process, thread, or
swap space limit was reached.
I did the db2mtrk on the system and the output is below:
Tracking Memory on: 2009/12/21 at 22:54:07
Memory for instance
Database Monitor Heap is of size 32768 bytes
Other Memory is of size 13565952 bytes
Backup/Restore/Util Heap is of size 4341760 bytes
Package Cache is of size 2146304 bytes
Catalog Cache Heap is of size 589824 bytes
Buffer Pool Heap is of size 420937728 bytes
Buffer Pool Heap is of size 6389760 bytes
Buffer Pool Heap is of size 743522304 bytes
Buffer Pool Heap is of size 330481664 bytes
Buffer Pool Heap is of size 33062912 bytes
Buffer Pool Heap is of size 606208 bytes
Buffer Pool Heap is of size 344064 bytes
Buffer Pool Heap is of size 212992 bytes
Buffer Pool Heap is of size 147456 bytes
Lock Manager Heap is of size 43384832 bytes
Database Heap is of size 15548416 bytes
Total: 1615314944 bytes
Last month I created new TS with 8K page and created one 8k Bufferpool with 400MB size. But the system is working as normal and there was no memory issues.
But now i am seeing this errors. How can I resolve this? Please post your suggestions.
Thanks.