RE: Getting table extents from sysmaster

Here is part of what you want... select tabname[1,15], ti_nextns xt, ti_nptotal, ti_npused, ti_nrows, ti_nextsiz from systabnames, systabinfo where dbsname = "your_database" and partnum = ti_partnum and tabname not matches "_temp*" order by 2 desc, 1 Join it to systabextents with te_partnum=partnum to get the chunk number of the table. Then link to syschktab to the dbspace number. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Andy Kent > Sent: Wednesday, 3 December 2003 5:09 a.m. > To: informix-list@iiug.org > Subject: Getting table extents from sysmaster > > > How can I write queries showing which table has extents in which > dbspace through sysmaster? - a bit like an oncheck -pe except I want > to condense the output with aggregate functions. > > I can see a table called systabextents but I can't fathom out what I > should join it to. > > Thanks > > Andy sending to informix-list