Re: How many pages allocated for a table under Infx5 ?

Posted in 1998

Stan Hixon — Wed, 06 May 1998 15:07:19 -0400 — source: Informix-list mailing list archive (1991-1998)

jeffso@lucent.com wrote: > > Is there anyway I can find out how many pages allocated for a particular table > under Informix 5 beside "tbcheck -pt". > I would like to do this as what I did in Infx7 engine - from system category. > But it doesn't seen to have a field "totpages". Any idea? Thanks. > I use "tbstat -t" during tracking of active tables, and look under tblnum, npages and nused. If I want to see most or all of the tables I make a query that looks for the oldest data I can think of and run "tbstat -t -r 5" , and watch the tables scroll by. e.g. Tblspaces n address flgs ucnt tblnum physaddr npages nused npdata nrows nextns 0 303a148c 1 1 1000001 10000e 1262 12 0 0 1 ---------- Yours, Stan Hixon The BABY DBA GAC Colorgraphics hixons@cgprinting.com