Re: Determining which tables are in which chunk
This is a multi-part message in MIME format.
--------------8D0F669ADB312827D20E2017
Content-Type: text/plain; charset=us-ascii
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Transfer-Encoding: 7bit
Tan wrote:
> Has anyone written a script (or clever use of awk) to give a list of
> which
> tables are in which dbspace and chunk. Unless I am mistaken, this
> information is not simply available from the standard informix
> commands and
> it makes it very difficult to determine which table is causing the
> chunk to
> run out of space.
>
> Any help would be gratefully appreciated.
>
> Tan
You can get a complete list of tables and their placement thru the SMI:
select d.name, t.dbsname, t.tabname
from sysmaster:sysdbspaces d, sysmaster:systabnames t
where d.dbsnum = trunc(t.partnum / 1048576)
order by 1, 2;
If you want chunk information, you can add the syschunks table to the
select sentence.
best regards
claus
--------------8D0F669ADB312827D20E2017
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Claus Samuelsen
Content-Disposition: attachment; filename="vcard.vcf"
begin: vcard
fn: Claus Samuelsen
n: Samuelsen;Claus
org: Sysdeco Danmark A/S
adr: Gydevang 22 B;;;DK-3450 Aller'd;;;Denmark
email;internet: csa@sysdeco.dk
title: Systems Manager
tel;work: +45 4814 3000
tel;fax: +45 4814 3011
x-mozilla-cpt: ;0
x-mozilla-html: FALSE
end: vcard
--------------8D0F669ADB312827D20E2017--