Re: SMI Query: Informix ODS 7.11
Bill,
>
> I am looking for a query to obtain the following information from an
> Informix Online 7.11 engine:
> DBSpace Name, Table(s) (or other way around)
> I am trying to work on some tools to help us manage disk space on a large
> system, and i need to know what tables reside in each DBSpace.
This is a script I use, I hope it helps:
--------------------------------------------------
-- Script: 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;
--------------------------------------------------
Regards - Lester
#############################################################################
# Lester Knutsen lester@access.digex.net #
# Advanced DataTools Corporation Voice: 703-256-0267 #
# Grant group privileges for Informix databases with DB Privileges #
# Visit our Web page: http://www.access.digex.net/~lester #
# Washington Area Informix User Group: http://www.access.digex.net/~waiug #
#############################################################################