monitor tables - how to ?

Posted in 1998

Sadagopan, Sathish — Wed, 29 Jul 1998 11:07:10 -0400 — source: Informix-list mailing list archive (1991-1998)

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