Re: Which table is in which dbspace?
On Mon, 11 Sep 2000, Sally Woolrich wrote:
>
>
> I need an SQL to print out (using names!) which table is in which
> dbspace:
>
> dbspace1 table1
> dbspace1 table2
> dbspace2 table3
> dbspace3 table4
>
Here is a copy of Lester Knutsen's tblayout.sql, directly off his web site
(www.advancedatatools.com) or in my book:
-- 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;
________________________________________________________________________
Ron Flannery <mailto:rflanner@informixhandbook.com>, 248-887-8470x40
Lead author, Informix Handbook President, One Point Solutions
"Your Complete Reference" "Informix & Web/Database solutions"
http://www.informixhandbook.com http://www.one-point.com
________________________________________________________________________
> etc.
>
> I can't work out how to do it for myself, sadly, but I'm sure there's
> *someone*out there who does.
>
> Using IDS 7.30.UC3.
>
> TIA
>