Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2010
    Posts
    19

    Unanswered: how can i find the size of table

    hello

    how can i find the size of table in db2

    10x

  2. #2
    Join Date
    Apr 2010
    Posts
    10
    Many ways to check the table size....

    1) if you have control center on your work station then right click on the table and click on the estimate size option.this will show u the size of the table and indexes separately in Mb or Kb.

    2) You can check the table size by running a REORGCHK with update statistics. then one of the values displayed for each column is TSIZE that is the table size so just run runstats for the desire table.
    ## reorgchk update statistics on table schemaname.urtabname

    Remember to update your statistics before you select any value from the syscat tables.
    If you check the documentation for REORGCHK it will tell you the formula to calculate TSIZE from syscat tables.

    REORGCHK will return the size in bytes.

    Hope you find this useful

    Thanks,
    Amar

Posting Permissions

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