RE: table space ..
oncheck shows you the information, but you need to make a script and it is
slow.
You can take that information directly from sysmaster:systabinfo; the fields
are:
ti_partnum (key for joining to sysmaster:systabnames for tabname)
ti_nptotal (total pages allocated)
ti_npused (total pages used : data + index )
You just have to sum.
Carlos
> -----Mensaje original-----
> De: Art S. Kagel [SMTP:kagel@bloomberg.net]
> Enviado el: Lunes 4 de Diciembre de 2000 06:19 PM
> Para: informix-list@iiug.org
> Asunto: Re: table space ..
>
> oncheck -pt databasename:tablename>
> -OR-
>
> oncheck -pT databasename:tablename>
> Either will report allocated and used pages and also categorize the pages
> as to whether and how many are data, bitmaps, other overhead, index pages,
>
> etc. Also how many are partially -versus -completely full will be
> addressed
> in the -pT report beyond the summary that the -pt report provides.
>
> Art S. Kagel
>
> "Sinha, Niraj" wrote:
> >
> > Folks,
> > What would be the easiest way to find out the empty space in a DBSPACE.
> > What I am looking for is , even if I have given a huge extent for a
> > table in a DBSPACE, that table might not be occupying the whole extent.
> > So, essentially, how do I calculate actual space the data space for the
> > table
> >
> > Thx,
> > Niraj