Re: monitor tables - how to ?

in dbaccess the number of stores7 database's extent is: select b.tabname, a.ti_nextns from sysmaster:systabinfo a,stores7:systables b where a.ti_partnum=b.partnum and b.tabid > 99;-------------------------- tabname ti_nextns customer 1 orders 1 : : : : catalog 2 : : : : Sadagopan, Sathish 'ۼ''': > Hi, > How to find out how a table is spread out across a chunk in a dbspace ? > 1) If the dbspace has one chunk in it but many tables ? > 2) If there are more than one chunks in the dbspace ? > > The onstat -t output shows only one entry for a tablespace and the address > it > shows is the starting address of the first extent , i believe.How to find > where the > other extents are ? > I am trying to make a sketch of Disk/Dbspace/Chunk/Tablespace/Extent layout > and examine extent interleaving too. > > TIA > Sathish Sadagopan