Hi there,

I need to calculate space(together primary + secondary) with which TS was defined that also has 200+ partitions.

No matter if it is a segmented/simple/partitioned. I just want total space together primary+secondary.

Can somebody guide me where could I get this information from in catalog tables?

I tried in SYSIBM.SYSTABLESPACE - COLUMN SPACE, that does not give accurate results.

Steve Wawzynzak

Try looking at the stospace utility.

Marcus,

Thanks!

These are the PROD tables I am talkin about... is there any other way out?

Steve Wawzynzak

I don't understand your concern. The DB2 STOSPACE utility determines the amount of space allocated for DB2 storage groups and their related table spaces and indexes. The utility updates DB2 system tables with the information it gathers.

Output from this utility consists of DB2 updates to the following tables:

SYSIBM.SYSINDEXES
SYSIBM.SYSTABLESPACE
SYSIBM.SYSSTOGROUP

After STOSPACE execution is complete, use an SQL SELECT to view the tables that STOSPACE changed.

DB2 for z/OS?
If you say "with which it was defined", do you mean "how can I read from the catalog which were 'n' and 'm' ", in ?
Have a look at the two columns PQTY and SQTY in sysibm.systablepart.
Then multiply those numbers with 4 to obtain 'n' and 'm' respectively.