Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2001
    Location
    Chennai
    Posts
    6

    Unanswered: Space required for a table

    Hi All,
    Is there any way to estimate the space required for a table given number of rows and average byte length per row.
    I am working on an application and i need to calculate this .
    Is there a standard forumla to calculate the same

    Thanks in advance
    Vigneshwaran

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Space required for a table

    You'll find information in the 'Physical Database Design' Chapter of Administration Guide ...

    If the table is already created, you can use the 'Estimate Size' in the drop down menu when you right-click on the tablename...

    Cheers

    Sathyaram

    Originally posted by Vigneshwaran
    Hi All,
    Is there any way to estimate the space required for a table given number of rows and average byte length per row.
    I am working on an application and i need to calculate this .
    Is there a standard forumla to calculate the same

    Thanks in advance
    Vigneshwaran

  3. #3
    Join Date
    Jul 2002
    Posts
    19

    Re: Space required for a table

    Originally posted by sathyaram_s
    You'll find information in the 'Physical Database Design' Chapter of Administration Guide ...

    If the table is already created, you can use the 'Estimate Size' in the drop down menu when you right-click on the tablename...

    Cheers

    Sathyaram
    vignesh
    sathyaram is right you can find the info in Physical database design section of admin guide

    this is the link for online doc that will be of help to you
    regards
    Gajendran

    http://www-3.ibm.com/cgi-bin/db2www/....htm#HDRDBSIZE

Posting Permissions

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