Re: Finding dbs for table
Hello,
>
> I am looking for a way to find in what dbspace (or chunk) is particular
> table.
> Can anybody help me?
DO you have version 7.X? Here is a script from my sysmaster collection
that works for version 7. For version 5.X you can use tbcheck -pe.
-----------------------------------------------------------------------------
-- 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;
#############################################################################
# Lester Knutsen lester@advancedatatools.com #
# Advanced DataTools Corporation Voice: 703-256-0267 #
# Grant group privileges for Informix databases with DB Privileges #
# Visit our Web page: www.advancedatatools.com #
# Washington Area Informix User Group: www.iiug.org/~waiug/ #
#############################################################################