Re: Calculating extent sizes

Posted in 2010

wimpunk — Tue, 16 Nov 2010 17:41:49 +0100 — source: Usenet: comp.databases.informix

On 2010-11-15, JonnyTDI@Usenet-News.net <JonnyTDI@Usenet-News.net> wrote: > > Extent size "doubling" ... i.e. you loaded a table which had an initial > extent size of 131072 ... extent 1 filled up and then the server > allocated a new extent and as it was able to allocate contiguous space > it concatenated the extent ... this happened a few times :P (I make it 35!). > > Much easier to understand this using oncheck -pt output. Thanks for the clarification! I had a problem runnign oncheck -pt as user informix but I just discovered I had to run it as root. Regards, wimpunk.

↪ replying to wimpunk

Fernando Nunes — Tue, 16 Nov 2010 17:38:05 +0000 — source: Usenet: comp.databases.informix

?! No you don't... Something must be wrong in your installation... Did you install the server properly or copied the files from another place/system? Regards. On Tue, Nov 16, 2010 at 4:41 PM, wimpunk <ybwdlapvxvun@spammotel.com> wrote: > On 2010-11-15, JonnyTDI@Usenet-News.net <JonnyTDI@Usenet-News.net> wrote: > > > > Extent size "doubling" ... i.e. you loaded a table which had an initial > > extent size of 131072 ... extent 1 filled up and then the server > > allocated a new extent and as it was able to allocate contiguous space > > it concatenated the extent ... this happened a few times :P (I make it > 35!). > > > > Much easier to understand this using oncheck -pt output. > > Thanks for the clarification! > I had a problem runnign oncheck -pt as user informix but I just > discovered I had to run it as root. > > Regards, > > wimpunk. > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...