Results 1 to 5 of 5

Thread: Table Size

  1. #1
    Join Date
    Oct 2008
    Posts
    82

    Post Unanswered: Table Size

    how to find the table size?
    any query is there to find out table size?
    and without using query how to find table size?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What do you mean by table size? number of rows? number of bytes?

    There is no way without a query to determine size.

    Andy

  3. #3
    Join Date
    Oct 2008
    Posts
    82

    Table size

    i want no of bytes
    without using query we can get by using runstats am i right...?


    Thanks in advance

  4. #4
    Join Date
    Oct 2008
    Posts
    82

    Cool TAble size

    Hello

    sorry not runstats.... by using reorgchk we get one column about table size.....is it useful to find the table size..

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    What does count to the table size? Do you include free space allocated in pages for the table? With simple tablespaces (DB2 z/OS), you can have rows from different tables on the same page - how do you deal with that? How about regular overhead like record headers, page headers, ...

    Basically, for DB2 LUW you will find in the manual all the formulas to do space estimates for tables.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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