Re: defining logical and physical log size

Nancy wrote: > > I work with the Informix-Online 7.13. > > Does anyone know an easy way to calculate the sizes for the logical and > physical logsizes. > > I've read the manuals, and even the trainings manuals but there is nothing > that says me otherwise than to make a wild guess as to there size. > > Please mail me mihc3@ibm.net or just reply. Nancy It's a matter of suck-it-and-see. The sizes depend upon the level of update activity, checkpoint duration etc. But the orthodoxy is to start with logical logs of 20% of the total database size, and physical logs of 5%. There's some discussion on this subject in the Informix User Group Forum FAQs - iiug.something-or-other - a search engine will find the exact address. Neil Truby Chase Bank Bournemouth, UK