Re: Which table is in which dbspace?
SELECT DBINFO("DBSPACE", partnum) dbspace, tabname
FROM systables
WHERE tabtype = "T"
and tabid > 99
and partnum > 0
and partnum IS NOT NULL
"Obnoxio The Clown"
<obnoxio@hotmail.com> To: sally.woolrich@comino.com, informix-list@iiug.org
Sent by: cc:
owner-informix-list@iiu Subject: Re: Which table is in which dbspace?
g.iiug.org
09/11/00 08:27 PM
select dbsname,
-- owner,
tabname,
te_extnum,
trunc((te_physaddr / 1048576)) chunk_num
-- te_pagenum,
-- te_size
from sysmaster:systabnames st, sysmaster:systabextents te
where te.te_partnum = st.partnum
order by chunk_num, dbsname, tabname, te_extnum
according to <MATTHEWP@visa.com>
:-)
From: sally.woolrich@comino.com (Sally Woolrich)
>
>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
>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
-------------------------------------------------------------------------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.