Re: Initial Extents

In article <6cv80h$lve$1@news.xmission.com>, Herb Blacker <herbb@jcdcrs4.jobcorps.org> writes > >Is there an upper limit to initial extents? I'm running ODS 5.02 and I've >got one table at 846,000 pages, and several at 300,000-400,000 pages, >including indexes. Calculating the extent size at 4KB per page, my >largest initial extent size is around 3,385,000 KB. Is this reasonable? >Should the next extent size be declared at 20% of initial? >I've read TFM, and it doesn't give any limit. >TIA, I think the limit is 2Gb i.e. the size of a chunk as extents do not span chunks. Remember if you do not specify an initial size that a small default is used and it doubles every 16 extents. ADJACENT EXTENTS ARE CONCATENATED TOGETHER. This doubling and concatenating would explain the extent sizes you are getting. >------------------------------------------------------------------------ >Herb Blacker >Cimarron, Inc. >Database Administrator - DOL Job Corps San Marcos, Texas >------------------------------------------------------------------------ > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care