Re: size of rootdbs

97.66 MB is my smallest. the others are close to that, i.e. around 100 MB. ----- Original Message ---- From: "Sebastian, Norma J." <NormaJean.Sebastian@tellabs.com> To: Keith Simmons <smiley73@googlemail.com>; doitman <sunil.saggar@gmail.com> Cc: informix-list@iiug.org Sent: Thursday, November 30, 2006 8:41:27 AM Subject: RE: size of rootdbs Wow, I see an interesting survey in this..... Who has the largest and smallest rootdbs in a production environment ;) Norma Jean Sebastian ERP Support Administration GIS- Enterprise Technical Services -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Keith Simmons Sent: Thursday, November 30, 2006 4:43 AM To: doitman Cc: informix-list@iiug.org Subject: Re: size of rootdbs On 30 Nov 2006 02:19:10 -0800, doitman <sunil.saggar@gmail.com> wrote: > Thanks Keith. > > # LTXEHWM should be atleast 30% so that we could minimize log overrun > issue. > > DYNAMIC_LOGS 2 > LTXHWM 50 > LTXEHWM 60> > Dynamic logs are ON. > meaning that it will be created when previous logs fills up ..right ..? > from where these logs will be created . rootdbs ? > > > One more thing : > If i create logdbs and create the logs in that logdbs(after the system > initialization) > leaving a few logical logs in rootdbs . > Now when the logs fills up , will they be created from logdbs or > rootdbs? > > Thanks. > Keith Simmons wrote: <SNIPPED> > > > > 15 Gb is far too big, but I suspect you have few (if any) other > > dbspaces! You need to reduce it in size, however this involves > > re-initialising your instance and trashing all the data! > > 1 Gb is probably big enough, put your PHYSFILE (which is also possibly > > a bit large at 950 Mb) into its own dbspace and move all your LOGFILES > > into their own space(s).> > Create specific dbspaces in which to create your databases and you > > will improve performanceand vastly reduce the risk of filling your > > root dbspace and all its attendant heartache. > > Many dbspaces also open the possibility of parallel archives. > > > > Keith > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > Sunil New logs will be created when ALL existing logs are filled and not backed up. These will be created firstly where the existing logs are and then in root dbspace. I know of no reason why you would want to leave any logs in rootdbs, move them all into their own space(s). What is this 'log overrun issue', 5.4Gb of log space should be more than sufficient and if you have a single transaction of this size, or a long transaction spanning 50% of this log space then you have BIG applicatio problems somewhere!! Keith _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================ _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list