Re: defining logical and physical log size

Before you can start to do this you will need to know the volume of change per day in your database and for each table. Then you can apply statistical sampling to determine the maximum number of changes in a given period. That, combined with knowledge of potential long transactions can be used to calculate both the physical and logical log sizes. It takes a lot of figuring though > 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. Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc