Re: Informix Maximum Chunk Size

Thomas Parsli wrote: > > "Obnoxio The Clown" <obnoxio@hotmail.com> writes: > > > From: lkcho@my-deja.com > > > > > >I am using Informix 5.10c. Could anybody know what is the maximum size > > >for each chunk for Informix database. We had tested that it only > > >allows maximum of 2 Gigabytes in Informix 5.08c. Is there any > > >possibilities to expand the size of each chunk after upgrading to > > >Informix 5.10c. > > > > It's still 2GB. > > Can someone tell me why this is a "problem"? > Questions like this pops up all the time, and many believes this > is a _limit_ in Informix/IDS/whatever. > > Isn't this a non-problem unless your database is _very_ large > (Way larger than 1TB)? In 7.xx/8.xx/9.xx it is not a problem at all since these support 1024 chunks per server, but OL5.xx only has one disk page for the chunks table which holds a maximum of 64 chunks if their paths are 3 characters or less (imagine /aa /ab /ac /ad ... /da ...) and about 55 chunks if their paths are less than 7 characters (I use /i/ix01, /i/ix02 ....). Actually those counts are 1 too high since a bug in tbspaces and tbmonitor will not let you add a chunk if there are not 65 bytes free for the next entry even though entries for pathnames that small are about 56-60 bytes. Since it is impractical to actually achieve 64 chunks you have to settle for a max of 54 chunks if you are VERY careful naming them for a total of 108GB per server. Art S. Kagel