Re: 2GB Chunk & Extent Size Limit ?

Richard Ridley wrote: > > Sorry if this is has been asked before, but I can't understand the > answers I have been getting ! > > Using Informix 5 or Informix 7, is the size of a chunk still limited > to 2GB ? (We use HP-UX 10.10 and 10.2). Yes. > If so, does this effectively restrict the size of an extent to 2GB as > well (since one extent cannot span across chunks ?) ? No. An extent is part of a table space. A table space is limited in size by the size of the dbspace (unless it is fragmented). A dbspace can have one or more chunks allocated to it. ^^^^^^^^^^^ There is a limit to the number of chunks you can allocate in all, 2048 if my memory serves me. > I am having problems believing this - how do people maintain > terabyte-sized databases without having more than the recommended > limit of 8 extents ??? (I realise that there will be more than one > table, but surely some tables must exceed the recommendation ?) Because an extent CAN span chunks. :-) But also 7.x allows tables to be fragmented across dbspaces. :-) Hope that helps, -- Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+