Get information on the used extents of tablespace

Pandora-Box · Posted: Thu Jun 05, 2008 11:11 pm

Is it possible to get information on the used extents of tablespace from systablepart and systablespace ?
Where systablepart -> I will be having the information on PQTY, SQTY AND SPACE.
How the used extents calculated from these quantities.

Thanks,
Prem

am_ne · New User Joined: 24 Mar 2007 Posts: 25 Location: Bangalore

No. I don't think its possible as storage mechanism depends not only on pri quantity/ sec quantity but also depends on the parms like COMPRESS/PCTFREE/FREEPAGE etc...

If you know the underlying vsam cluster name then you can issue listc command to know the used extents.

Thanks
Amit

Pandora-Box · Posted: Sat Jun 07, 2008 4:06 pm

Thanks am_ne yeah I know that option but I am trying to build something in the form of a report for a set of tablespaces that why I checked if it was feasible

.

Regds,
Prem