Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399

    Unanswered: how much instance_memory used by instance?

    is there a way to find out exact amount of memory used by an instance? dbm cfg parameter 'instance_memory' is set to automatic and we can not figure it out. Tried db2pd and it did give same 'automatic' which does not help. Manual says it's allocated when intstance is started and we need to find exact number. Thanks
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    try "db2pd -dbptnmem" if you're using db2 v9.5

  3. #3
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    thanks, Bella. What exactly should I look for in the db2pd report? I think I would probably have to add up few numbers to get total amount, is that right?
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    Look at the "Current usage" value. This will give you the amount of memory your instance is currently using.

  5. #5
    Join Date
    Nov 2007
    Posts
    72
    db2mtrk tool will tell you ...

Posting Permissions

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