Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
c-eriks@algonet.se — — source: Informix-list mailing list archive (1991-1998)
Hi!
In my efforts to "eliminate extent interleaving" I came about to study
the distribution of table extents among dbspace chunks. For a specific
table I want to know in what chunks it's extents are located. (I can do
a "oncheck -pe | more" and look through the output but I want to query
the SMI-tables instead). Any ideas about such a sql-query?
What I then want to do is a "ALTER INDEX TO CLUSTER" on a table
(described in INFORMIX-Online Dynamic Server, Administrator's Guide,
Volume 1 Version 7.1", page 15-23) to rebuild the table with _one_
extent only. My focus on chunks is because of the following lines in
the Guide: "The chunk must contain adequate contiguos space in which to
rebuild the table". But what if the table has extents in many chunks?
Does anybody have experience in doing such a rebuild of a table?
Sent via Deja.com http://www.deja.com/
Before you buy.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.