RE: Which table is in which dbspace?
----------------------------------------------------------------------------
-
-- Module: @(#)tablayout.sql 1.4 Date: 97/07/18
-- Author: Lester B. Knutsen Email: lester@advancedatatools.com
-- Advanced DataTools Corporation
-- Discription: Displays 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;
-----Original Message-----
From: sally.woolrich@comino.com [mailto:sally.woolrich@comino.com]
Sent: Monday, September 11, 2000 6:16 AM
To: informix-list@iiug.org
Subject: Which table is in which dbspace?
I need an SQL to print out (using names!) which table is in which
dbspace:
dbspace1 table1
dbspace1 table2
dbspace2 table3
dbspace3 table4
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