RE: extents of tables
Run the following SQL against the sysmaster database: It produces a list of
databases, tables, table space size in Kb (Assuming a 2K page size) and
number of extents.
select dbsname, tabname, sum(size * 2), count(*) from sysextents group by
1,2 order by 4 desc, 3 desc
> -----Original Message-----
> From: PaulITID.Matthews@chase.com [SMTP:PaulITID.Matthews@chase.com]
> Sent: 28 October 1998 17:47
> To: deeky@my-dejanews.com
> Cc: informix-list@iiug.org
> Subject: Re: extents of tables
>
> If you use DBCOCKPIT, the gui monitoring tool that comes with v7 releases,
> you get a very nice little window that pops up telling you which tables
> have breached extents limits
>
> Paul Matthews
>
>
>
>
> deeky@my-dejanews.com on 27/10/98 12:33:10
>
> Please respond to deeky@my-dejanews.com
>
>
> To: informix-list@iiug.org
> cc: (bcc: Paul'ITID' Matthews/CHASE)
> Subject: Re: extents of tables
>
>
>
>
>
> > > 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
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>
>