Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2006
    Posts
    27

    Unanswered: Problem when calculating DBHEAP

    hi all,

    I want to calculate DB2 heap size (DBHEAP). In version IBM give the formulas:
    In bytes:
    (logbufsz * 4K)
    + 10K per table space
    + 4K per table
    + ( 1K + 4*extents used ) per range clustered table (RCT)

    However I do not know how to calculate the value ( 1K + 4*extents used ) per range clustered table (RCT)

    Anyone can guide me how to get the information to calculate this values. Plz give me an example if it is possible.

    Thx much

  2. #2
    Join Date
    Mar 2003
    Posts
    343
    which version is this calculation for?

  3. #3
    Join Date
    Jun 2006
    Posts
    27
    it is version 8.1 fixpak 7

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I have not seen that calculation. Assuming your logbufsz is 256 or less (which it should normally be), the almost every database can use 2048 for dbheap with plenty to spare. In version 7, dbheap depended on the size of the bufferpools, but this is no longer true.

    You really should upgrade to the latest fixpack because FP7 is the first release of 8.2 and it has a lot of bugs. There have been more than 1500 APARs fixed in the fixpacks after FP7.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Jun 2006
    Posts
    27
    We just upgraded to fixpak 9 yesterday.

    The formulas is from IBM for fixpak 4 and newer:

    http://www-1.ibm.com/support/docview...id=swg21141490

Posting Permissions

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