Re: Pages used per table

Bill, I should have been alittle clearer. By "tablespace info" I meant that you would get the total pages allocated for the table. But with the capital T option, Russ could then tell how many pages were allocated to data, how many were allocated for the indexes and how many free pages there were in the tablespace. These values often become important when trying to manage limited disk space. Sorry for the lack of clarity. ========================================================================= = Tracy W. Nedd = = Banctec Inc. - DBA = = Silver Spring, Md = = tracyn@asd.banctec.com = ========================================================================= = ALL RIGHTS RESERVED. = = This posting is copyright and may be used only for the purposes = = of professional study. Use of this posting in any commercial = = environment is explicity prohibited. This posting may only be = = reproduced for personal archival purposes. = ========================================================================= > > dd (tracyn@asd.banctec.com) wrote: > : Bruce, > : Russ' answer is partially correct. If you want the index info too, then > : run 'oncheck -pT <database>:<table>' > : This will give you the info you require, the lowercase 't' option just > : gives the tablespace info. Have fun, > : > : Tracy > > oncheck -pt WILL show you total pages allocated to the table. This> includes index pages. > > ---------------------------------------------------------------------------- > Bill Glidden Sr. Advanced Support Engineer > E-mail: glidden@informix.com Advanced Support > (415) 926-6904 Informix Software, Inc. > ---------------------------------------------------------------------------- >