Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003

    Unanswered: what is the fixed overhead per row?

    I am trying to calculate the size of tablespace using the following formula:

    size = ( [no. of rows ] * [row size] ) / 1024
    //1024 is used to get size in KB.
    increasing the size by 50% at safer size . allocating half of the above size to index tablespace. Can any one fine tune it furthur? is there any thing like fixed overhead per row in db2 ?

    thanks in advnc

  2. #2
    Join Date
    May 2003
    If you are talking about DB2 for UNIX, Linux, and Windows, refer to the "DB2 UDB Administration Guide: Planning." They have several formulas for estimating the size of tables and indexes. The formulas take into account both row overhead and page overhead.

    I am sure that the DB2 S/390 manuals have similar formulas.

Posting Permissions

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