RE: How many logical log is needed
From: JasonYLPang@pg.SLR.com > >I have increased the log space from 2G to 3G. However, I'm still getting >the >long transaction rollback. why? Because you still don't have enough log space? What kind of transactions are you doing, anyway? >-----Original Message----- >From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] >Sent: Saturday, July 15, 2000 8:30 PM >To: Pang, JasonYL; informix-list@iiug.org >Subject: Re: How many logical log is needed > > >From: JasonYLPang@pg.SLR.com > > > >The size of database is around 40G. Currently, I have 100 logical log >with > >each log 20MB (Total is 2G). Is my logical log size sufficient to support > >my > >database? Recently, I'm facing a lot of long transaction. Is it because >of > >insufficient logical log?? > >I couldn't tell based on the size of your database and the size of your >logs > >whether you have sufficient space. However, the fact that you're getting >lots of long transaction rollbacks hints that you don't have enough log >space. >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
Hi, This sounds cliche`, but the issue is probably that your application needs to be modified to do more commits. Even if you added another 2gb and stopped getting longtx's, what if there is a problem and it has to rollback. How long would it take? We had a situation where we had LTXHWM/LTXEHWM set to 50/60 and the logs still filled during longtx rollback. BIG MESS. Informix had to dial in and the application was down for almost a whole business day (they added another logical log with the DB down). So, we now use 45/50 for LTXHWM and LTXEHWM. Anyway, I would work on the application side more if you can. Good Luck, Bill Border Agilent Technologies bb22@uswest.net Cool, Affordable DB Monitor: http://dbamon.com Obnoxio The Clown wrote in message <8ks5ie$cju$1@news.xmission.com>... > >From: JasonYLPang@pg.SLR.com >> >>I have increased the log space from 2G to 3G. However, I'm still getting >>the >>long transaction rollback. why? > >Because you still don't have enough log space? > >What kind of transactions are you doing, anyway? > >>-----Original Message----- >>From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] >>Sent: Saturday, July 15, 2000 8:30 PM >>To: Pang, JasonYL; informix-list@iiug.org >>Subject: Re: How many logical log is needed >> >> >>From: JasonYLPang@pg.SLR.com >> > >> >The size of database is around 40G. Currently, I have 100 logical log >>with >> >each log 20MB (Total is 2G). Is my logical log size sufficient to support >> >my >> >database? Recently, I'm facing a lot of long transaction. Is it because >>of >> >insufficient logical log?? >> >>I couldn't tell based on the size of your database and the size of your >>logs >> >>whether you have sufficient space. However, the fact that you're getting >>lots of long transaction rollbacks hints that you don't have enough log >>space. >>________________________________________________________________________ >>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com >