Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2008
    Posts
    76

    Unanswered: Calculate size of a partitioned table and its indexes

    Folks,

    How to calculate the size of a partitioned table and its indexes ?


    Thanks in advance,
    Panditt

  2. #2
    Join Date
    Oct 2007
    Posts
    246
    sysibmadm.admintabinfo can give u the details

    regds
    Paul

  3. #3
    Join Date
    Aug 2008
    Posts
    76
    Hi Paul,

    Thanks for your reply. But this admin view does not show the index size for a partitioned table. It shows it as zero and this is mentioned in info center too.

    Any other way ?

    Thanks,
    Panditt

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    What's wrong with multiplying NPAGES from SYSCAT.INDEXES by the page size of the tablespace?

Posting Permissions

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