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)? I think the main reason the question arises is that people forget to purchase a LSM, or perhaps don't know they have one. :-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+
On Tue, 1 Aug 2000 22:27:53 +0100 , "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> wrote: > >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)? > >I think the main reason the question arises is that people forget to >purchase a LSM, or perhaps don't know they have one. :-) Now what does LSM stand for? Lager & Spirits Manager? > >Cheers, >-- >Mark. > >+----------------------------------------------------------+-----------+ >| Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| >| http://www.informix.com http://www.informixhandbook.com |///// / //| >| http://www.iiug.org +-----------------------------------+//// / ///| >| |This email will self-destruct in |/// / ////| >| |10 sec. If you received this email |// / /////| >| |in error, sorry about the mess. |/ ////////| >+----------------------+-----------------------------------+-----------+
sally.woolrich@comino.com (Sally Woolrich) writes: > On Tue, 1 Aug 2000 22:27:53 +0100 , "Mark D. Stock" > <mdstock@mydas.freeserve.co.uk> wrote: > > > > >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)? > > > >I think the main reason the question arises is that people forget to > >purchase a LSM, or perhaps don't know they have one. :-) > > Now what does LSM stand for? Lager & Spirits Manager? Yepp, there's no need for a LVM if you've got enough LS(M)... Thomas (you'r one of the latter ones then?;)