Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2013
    Posts
    4

    Unanswered: Real memory used by the db

    Hello,

    Meanwhile, I greet all of you as they are a new member of the site.
    I have a question to ask yourself.

    I have a doubt about the memory consumption by the db.
    Running the command: db "db2pd-db-dbptnmem" the consumption of the memory in use by the db is 1.3 GB.

    Instead using the command "ps aux | grep-i db | awk '{print $ 6}'" and making the sum of the values ​​returned in the output (in KB) I get 283 MB

    Where does all this difference? Should not coincide?
    I doing something wrong?

  2. #2
    Join Date
    Sep 2013
    Posts
    3
    the differences is the shared memory (IPS).
    most of the memory used by DB2 is a share one

    type: ipcs to list all the shared memory

  3. #3
    Join Date
    Sep 2013
    Posts
    4
    Thank you very much.
    The parameter DATABASE_MEMORY taken from db2 cfg corresponds exactly to the memory of the current db using the command db2pd - dbptnmem.

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    You can look at committed memory reported by mon_get_memory_set:
    IBM DB2 9.7 for Linux, UNIX and Windows Information Center

  5. #5
    Join Date
    Sep 2013
    Posts
    4
    Thank you very much db2girl!
    I will study carefully your link.

Posting Permissions

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