monitor tables - how to ? - figured it

Posted in 1998

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

Ah.... I saw the oncheck -pe option , seems to be what i want . Sathish.S > ---------- > From: Sadagopan, Sathish > Sent: Wednesday, July 29, 1998 10:07 AM > To: 'informix-list@iiug.org' > Subject: monitor tables - how to ? > > 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 >