Re: Actual Used space

In all of this conversation no one has commited that npused is the DATA size only! If my memory servers me correctly npused does not include the INDEX size that is being used by the table. This to me is important when you are want to factor the amount of space a Table is using. ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Wed, 11 Sep 1996, Srinivas Reddy wrote: } 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! | } } +------------------------+------------------------------------------------+ } } } } }