Re: My Whole World Fell Apart!!

Is the world falling out of your bottom? :-) On 26 Feb 98 at 11:21, Samuels David NTSE wrote: > I have a table called scpard it was created with an initial extent > of 620 Kb and a next extent size of 124 Kb. > I ran the following SQL Query, but did not get the results I > expected. Baring in mind that PE_SIZE is in 2 Kb Pages. I thought > the initial was going to be 310, which it was. Then my whole world > fell apart when the next extent was not 62 and all other extent > sizes seemed to be randomly sized. I really do need to know why > this is, in order to recalculate the next extent size correctly. Well, it could be that some of the extents were created adjacent to each other. This would then appear to create randomly sized extents. In other words, there are just more 124KB extents than are immediately apparent, as they have merged into odd sized contiguous extents, > Is there some sort of weighted factor like Oracle's PCTINCREASE and > furthermore what is the rationale behind this bizarre extent > allocation sizes. Or why even specify a next extent as it seems to > ignore it anyway! Every 16 extents your next extent size will automatically double. Or 32. I can never remember... :-) HTH. -- /Ciao, \\Billy / \\Group Managing Director, The West Solutions Group: http://www.west.co.za / Chairman, South African Informix User Group: http://www.west.co.za/~saiug \\ Informix FAQ @ http://www.iiug.org/techinfo/faq/faq_top.html / Drivel @ http://www.west.co.za/tasteless/ \\________________________________________________________________________________________________