Re: Informix Maximum Chunk Size
Art, I know it was slip of fingers on your part but you did state 1024 chunks per server. BTW Manual plus training manual both say 2048 chunks. Here is the part of the message sent by you: > 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 Thanks Vivek ______________________________ Reply Separator _________________________________ Subject: Re: Informix Maximum Chunk Size Author: kagel (kagel@bloomberg.net) at internet Date: 8/1/00 11:08 AM vivek.chaudhary@st.com wrote: > > With all due respect max. no. of chunks per server is 2048. 2047 but who's keeping track. Did I say 1024? I couldn't have said 1024! %-) Art S. Kagel > Thanks > > Vivek > ______________________________ Reply Separator _______________________________ __ > Subject: Re: Informix Maximum Chunk Size > Author: kagel (kagel@bloomberg.net) at internet > Date: 7/31/00 9:41 AM > > > 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