Re: logical logs sizes

Clem Akins (clema@informix.com) wrote: : Let's clarify the issue of logical logs. (I think I've been talking : apples and the poor guy I "RTFM'd" was talking oranges.) : : > > Can anybody tell me an easier method for changing th logfile size on : > > I-Online 5.x than unloading the whole database and reloading it? : > : > There are several things you can do: : > 1) add more logs : > 2) change the size of the existing logs (without unloading/loading) : > 3) move the logs on disk (the physical and logical log *files*) : > 4) adjust high-water marks (are they too low?) : > 5) adjust locks while you're at it (lock level and number) : : There are three logical log sizes: : : Type: Location: Tbconfig: Description: : _______________________________________________________________________ : Holds records of changes until : Logical written to disk. Max number of : Log shared LOGSBUFF these buffers stored in LOGSMAX. : Buffers memory Just one correction. The number of logical log buffers is fixed at three. The size of the logical log buffers is tunable with LOGBUFF. LOGSMAX sets the maximum number of logical log files. ..... -- ___ ___ Principal Consultant / ) __ . __/ /_ ) _ _ __ Informix Software Inc. (303) 850-0210 _/__/ (_(_ (/ / (_(_ _/__) (-' ~/ '(_- 5299 DTC Blvd #740 Englewood CO 80111 dberg@informix.com Opinions expressed herein are my own. Eventually all things merge into one...and a river runs through it. -N.Maclean