Re: extents of tables

Posted in 1998

andy lennard — Tue, 27 Oct 98 15:42:45 GMT — source: Informix-list mailing list archive (1991-1998)

In article <714ei7$6uo$1@nnrp1.dejanews.com> deeky@my-dejanews.com writes: > In article <909423669snz@kontron.demon.co.uk>, > andy@kontron.demon.co.uk wrote: > > The 'sysmaster' database has a 'sysextents' pseudo-table that has this > > information. > > > > > From an Informix newbie: > > > > > > Can someone tell me how to get a report of the number of extents per table > > > (not just system tables but data as well)? I know about onstat -t but this > > > output seems kinda cryptic... > > > > > > I am running 7.24.UC5-1 > > > > > > TIA > > Thanks Andy.... > > But what information in this table tells me that I may be in need of a reorg? > Is it the size field... for example if a table says it has a size of 10 does > that mean 10 extents? > 'size' is the size of the extent, in pages (2k on my Sun, see your onconfig file). An 'explanation' of this table and others is in the Server Admin Guide. There's a section on the sysmaster database. Some more info can be found in $INFORMIXDIR/etc/sysmaster.sql. -- Andy Lennard andy@kontron.demon.co.uk