If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 Memory Issue

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-21-09, 18:16
dgunas dgunas is offline
Registered User
 
Join Date: Dec 2008
Location: Chennai
Posts: 110
DB2 Memory Issue

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.
__________________
Reply With Quote
  #2 (permalink)  
Old 12-21-09, 18:22
bulump bulump is offline
Registered User
 
Join Date: Oct 2009
Location: Calgary, AB Canada
Posts: 37
What else is running on the server?
Reply With Quote
  #3 (permalink)  
Old 12-21-09, 18:38
dgunas dgunas is offline
Registered User
 
Join Date: Dec 2008
Location: Chennai
Posts: 110
Currently nothing running on the server and nobody accessing the system.
__________________
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On