Re: table location
Try this,
select dbinfo("DBSPACE", pe_partnum ) dbspace,
dbsname,
tabname,
round(sum(pe_size)*2048/1024) size_kb
from sysmaster:sysptnext, outer sysmaster:systabnames
where pe_partnum = partnum
group by pe_partnum, dbsname, tabname
order by dbspace, size_kb DESC;
Vinod Bhansali
Informix DBA
DSL Transportation
>From: tienp@wholefoods.com
>Reply-To: tienp@wholefoods.com
>To: informix-list@iiug.org
>Subject: table location
>Date: Thu, 01 Jun 2000 13:03:37 -0500
>
>--------------15BF21438D382ED6D84ACA03
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>How do you find out which dbspace a table resides in? For example, I
>have a database that resides in db0, but I have database tables x, y,
>and z that are in db1, db2, and db3, but I don't know which is in
>which. These tables are not fragmented so an entire table resides in a
>dbspace. And please don't say check the system catalogs (sysfragments,
>systables) because I've done that. I'm looking for actual syntax, be it
>SQL or some oncheck parameter I'm not familiar with that will give me
>this info. Please copy any replies to: tienp@wholefoods.com. Thanks.
>
>--
>Phillip
>
>
>--------------15BF21438D382ED6D84ACA03
>Content-Type: text/html; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
><!doctype html public "-//w3c//dtd html 4.0 transitional//en">
><html>
>How do you find out which dbspace a table resides in? For example,
>I have a database that resides in db0, but I have database tables x, y,
>and z that are in db1, db2, and db3, but I don't know which is in
>which.
>These tables are not fragmented so an entire table resides in a
>dbspace.
>And please don't say check the system catalogs (sysfragments, systables)
>because I've done that. I'm looking for actual syntax, be it SQL
>or some oncheck parameter I'm not familiar with that will give me this
>info. Please copy any replies to: <a
>href="mailto:phillip.tien@wholefoods.com">tienp@wholefoods.com</a>.
>Thanks.
><p>--
><br>Phillip
><br> </html>
>
>--------------15BF21438D382ED6D84ACA03--
>
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com