Re: Logical log sizing

From: "Carlson@WHSmith" <carlson1@bellsouth.net> > >IDS 7.30.ucX >HPUX 10.20 >LTAPEDEV /dev/null> >I'm planning to implement some much needed maintenance on my systems >within the next few weeks. One of the areas includes physical / logical >log maintenance. > >A while back I threw out some extra logical log space; now it's time to >make the sizing thereof a bit more realistic. I've determined that I'll >use about 1250M of logical log space; the only issue is how large (or >small) to make the logical log size. Currently, I'm using 2M and 5M log >sizes. Doesn't really matter if you're not backing it up. :-) How about 100 x 12.5M? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Obnoxio The Clown wrote: > > From: "Carlson@WHSmith" <carlson1@bellsouth.net> > > > >IDS 7.30.ucX > >HPUX 10.20 > >LTAPEDEV /dev/null> > > >I'm planning to implement some much needed maintenance on my systems > >within the next few weeks. One of the areas includes physical / logical > >log maintenance. > > > >A while back I threw out some extra logical log space; now it's time to > >make the sizing thereof a bit more realistic. I've determined that I'll > >use about 1250M of logical log space; the only issue is how large (or > >small) to make the logical log size. Currently, I'm using 2M and 5M log > >sizes. > > Doesn't really matter if you're not backing it up. :-) > > How about 100 x 12.5M? > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com For now . . . I plan to start looking into transaction logging sometime after the New Year, so I'd like to plan ahead intelligently (for a change . . . <G>). -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */