Re: Actual Used space -Reply

Yes it is available in systables but the data is not correct. At a guess I would say that it is refreshed at 'Update Statistics'. The sysptnhdr table was recommended to me by Informix support as being the best source for this data. rgds -- -- Peter Tashkoff <tashkop@kiwi.co.nz> NZ Kiwifruit Marketing Board Usual disclaimers apply. This posting may not be used by any party to vilify another. >>> Srinivas Reddy <sreddy@costello.den.csci.csc.com> 12/September/1996 10:06am >>> Hi, Correct me if I am wrong. npused is available in systables. so you do not have to do a join. just select the tabname and npused from systables. more specifically : select tabname,npused from systables where tabid >99 if want this info for system catalogs then do not use tabid >99. Thanks & Regards, Srinivas Reddy On Wed, 11 Sep 1996, Mark D Stock wrote: } Jacques Renaut wrote: } > } > Wayne Kidd wrote: } > > } > > Does anyone have a query for the SMI tables or any other } > > tables, that will return the actual used space of a table. } > <SNIP> } > } > Try this query against sysmaster: } > } > select tabname, npused from systables, sysptnhdr } > where systabnames.partnum = sysptnhdr.partnum } } Er... npused is in systables. I don't have 7.x to hand to look at sysptnhdr, but is it } in there also. If so you will need to qualify the column with the table name. If not } then you don't need sysptnhdr. } } Cheers, } -- } } Mark. } } +-------------------------------------------------------------------------+ } |Mark D. Stock - The West Solutions Group http://www.west.co.za | } | | } |mailto:marks@west.co.za +------------------------------------------------+ } |Tel: +27 11 803 2151 |If it doesn't work... force it! | } |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | } |Cell: +27 83 250 2325 |Well, that's how I code anyway! | } +------------------------+------------------------------------------------+ } }