Re: dbspaces info
Hi,
I have a couple of scripts like this in my articule on the
sysmaster database at our web site.
The script are also at the www.iiug.org web site. The following
is closest to oncheck -pe:
-- tablayout.sql - Show layout of tables and extents
database sysmaster;select dbinfo( "DBSPACE" , pe_partnum ) dbspace,
dbsname[1,10],
tabname,
pe_phys start,
pe_size size
from sysptnext, outer systabnames
where pe_partnum = partnum
order by dbspace, start;
The articule is available at:
http://www.advancedatatools.com/Articles/sysmast.htm
Regards - Lester
David Williams wrote:
>
> In article <92ra2m$14p$1@news.xmission.com>, Tham Huei Hwan
> <hhtham@apis.dhl.com> writes
> >
> >Hi all,
> >
> >On which informix table, informix keep the info like dbspaces and chunks
> >size so that I can select from the table directly instead of running
> >'oncheck -pe'
> >
> >TQ
> >
>
> In database sysmaster
>
> tables
>
> sysdbspaces
> syschunks
>
> join on dbsnum
>
> --
> David Williams
--
______________________________________________________________________
Lester Knutsen lester@advancedatatools.com
Advanced DataTools Corporation Voice: 703-256-0267
Visit our Web page: http://www.advancedatatools.com
Washington Area Informix User Group: http://www.iiug.org/~waiug/
______________________________________________________________________