Re: Logical Logs Size

I don't know the exact reason,but when you set the size of logical log files to a large amount,you'll get shared memory error but after enlarging your shared memory size this will work properly. --babak >From: "Billy Wheeler" <billy@west.co.za> >To: mary@anasazi.com (Mary Curtis), informix-list@iiug.org >Date: Thu, 19 Nov 1998 08:16:27 +0200 >Subject: Re: Logical Logs Size > >On 18 Nov 98, at 16:16, Mary Curtis wrote: > administration group would like to see 50 megabyte logs. That's way >> too much shared memory for me, or is it?? > >I don't think it is. It's important to differentiate between the logical >logs and their buffers. The logical logs exist on disk, the buffers in >shared memory. So you can make your logical logs as big as just >under 2GB a piece, provided you have enough disk space available. > >> I'm looking for experience and recommendations on suggested >"larger" >> sized logs. Please also comment on the following concerns if you can: >> >> - shared memory (allocating to a bundle to large logs?) >> - long transactions (increasing the log sizes, have you decreased >> the long transaction high water marks? We're >> at 50/60 for LTXHWM/LTXEHWM) >> - recovery (as long as checkpoints are in line, are you >> safe? I've been in recovery on a long >> transaction and hence my concern above about >> rolling back forever and a day on a long txn) > >Chances are that you need either more logs and/or bigger logs if >you get a long transaction. > >> - checkpoints (any special considerations? We currently >> checkpoint at 150secs, duration usually 0-3 >> seconds, no complaints) >> - physical log size (any special considerations when increasing >> logical log size?) >> >> Anything else you think of, please share your experience. > >While you're about it, move your logical logs and physical log out of >rootdbs and into separate dbspaces on separate devices, preferably >with separate controllers. > >It's difficult to make informed comments on the other issues without >knowing a lot more about your transactions and data volume. Still, >HTH. >-- >Ciao, > >Billy > >"Give a man a match and he's warm for an hour, set him on fire and he'll be >warm for the rest of his life!" > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com