Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111

    Unanswered: 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.

  2. #2
    Join Date
    Oct 2009
    Location
    Calgary, AB Canada
    Posts
    38
    What else is running on the server?

  3. #3
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111
    Currently nothing running on the server and nobody accessing the system.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •