Calculate size of a partitioned table and its indexes

deshaipet · #1 (**permalink**) 01-10-11, 12:02

Folks,

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

Thanks in advance,
Panditt

Mathew_paul · #2 (**permalink**) 01-11-11, 02:44

sysibmadm.admintabinfo can give u the details

regds
Paul

deshaipet · #3 (**permalink**) 01-13-11, 22:59

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

n_i · #4 (**permalink**) 01-14-11, 03:07

What's wrong with multiplying NPAGES from SYSCAT.INDEXES by the page size of the tablespace?

Internet Services

Web Development

Digital Marketing

Consumer Tech