Re: Informix Maximum Chunk Size
With all due respect max. no. of chunks per server is 2048. 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
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