Results 1 to 6 of 6

Thread: dbheap HWM

  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Unanswered: dbheap HWM

    hi

    how to find dbheap HWM
    db2pd says but not able to calc which para

    kindly suggest
    regds
    paul

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Check the documentation for your version of db2

    9.7's is here
    dbheap - Database heap configuration parameter - IBM DB2 9.7 for Linux, UNIX, and Windows
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    For dbheap, I use PhyHWM reported by db2pd -mempools. You could also use db2mtrk with -w option.

  4. #4
    Join Date
    Oct 2007
    Posts
    246
    thx sathya and bella,
    bella
    and guide or link for clear describe of db2pd -mempools etc
    regds
    Paul

  5. #5
    Join Date
    Oct 2007
    Posts
    246
    hi bella
    the values for dbheap which snapshot gives like configured size for example
    45 MB = (dbheap + logbuffsz + catalogcache)
    kindly suggest
    regds
    Paul

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    I don't have any additional information. Maybe contact IBM if the documentation is unclear

Posting Permissions

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