Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2012
    Location
    Ukraine
    Posts
    24

    Unanswered: Private memory consumption

    Hello Guys,

    I've got DB2 10.1.0.2 Purescale installed on RHEL 6.3 x64, there are two servers in purescale cluster. I have different "PRIVATE" memory usage on them.

    Server1:

    db2pd -dbptnmem

    Database Member 0 -- Active -- Up 175 days 07:52:01 -- Date 2013-10-14-09.24.45.430781

    Database Member Memory Controller Statistics

    Controller Automatic: Y
    Memory Limit: 63495240 KB
    Current usage: 31744000 KB
    HWM usage: 63415872 KB
    Cached memory: 964544 KB

    Individual Memory Consumers:

    Name Mem Used (KB) HWM Used (KB) Cached (KB)
    ================================================== ======
    APPL-DB3 160000 160000 157632
    APPL-DB1 26944 415104 8640
    APPL-DB2 160000 160000 151424
    DBMS-db2sdin1 626432 626432 253120
    FMP_RESOURCES 22528 22528 0
    PRIVATE 467968 593280 0
    DB-DB2 2097152 2097152 0
    DB-DB1 26214400 26214400 0
    DB-DB3 1968576 1968576 393728



    Server 2:

    db2pd -dbptnmem

    Database Member 1 -- Active -- Up 188 days 09:22:37 -- Date 2013-10-14-09.24.30.497496

    Database Member Memory Controller Statistics

    Controller Automatic: Y
    Memory Limit: 63495240 KB
    Current usage: 35752704 KB
    HWM usage: 63501248 KB
    Cached memory: 592832 KB

    Individual Memory Consumers:

    Name Mem Used (KB) HWM Used (KB) Cached (KB)
    ================================================== ======
    APPL-DB3 160000 160000 157440
    APPL-DB1 38592 386304 384
    APPL-DB2 5568 160000 1024
    DBMS-db2sdin1 365760 626432 40256
    FMP_RESOURCES 22528 22528 0
    PRIVATE 4880000 4880000 0
    DB-DB2 2097152 2097152 0
    DB-DB1 26214400 26214400 0
    DB-DB3 1968576 1968576 393728
    LCL-p23075 128 128 0


    Server 2 has considerably higher "PRIVATE" memory usage. How can I investigate what is using so much memory for "PRIVATE"?

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    See http://www.dbforums.com/db2/1683488-...-question.html, but the information 'db2pd -memb pid' provides is more for DB2 Support than DBA's. There could be some new functions/admin routines in v10 that I'm not aware of. I think it's best to open a pmr.

Posting Permissions

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