Posted in 2000
Topics: Storage & Space Management, Versions, Editions & End-of-Life
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
>
We use strictly necessary cookies to make this site work. With your consent we’d also use optional cookies for analytics and marketing. You can accept all, reject all, or choose. Read our Cookie Policy.