> > Eric,
> > I believe this info is not available via the catalog.
> > I have a simple ksh script which puts the list tablespace output into
> > a table (+ timestamp, partition info)
> > This allows for easy trend analysis etc... subsequently.
> > Paul.
> > > Hello,
> > > does anybody know if it is possible to get number of
> > > free pages listed by the command "db2 list tablespaces show detail"
> > > directly from the data-dictionary ?
> > > There is a table called "sysibm.tablespaces" but the
> > > information about the number of free pages seems not
> > > to be available.
> > > For monitoring purposes I would prefer an SQL-Query of the
> > > data-dictionary to get the number of free pages.
> > > With Informix you can do it using the sysmaster-database
> > > (Tables: sysdbspaces/syschunks).
> > > Is there something comparable in DB2 (Unix) ?
> > > We are using DMS tablespaces (raw devices).
> > > Thank you in advance.
> > > Best regards
> > > Eric
> Paul,
> If possible , can I have copy of this script. My idea to put these
> 'numbers' in a worksheet.
> Thanks,
> VKG
I have e-mailed you & Eric a copy of the script on an as-is basis.
NB. The nice thing is the script will concurrently collect all the
tablespace info on all the partitions in parallel (and treats EE
as a single parition version of EEE). So, it runs quickly on
large EEE installations.
by