Re: How to size the logical log ?

On 7 Apr 98 at 11:17, Timothy_Lam@crow.bmc.com wrote: > Hello Guys, > > Does anybody know how to calculate the size of the logical logs > ? There is a formula in the Administrator's Guide. Or at least I thought there was: having just scanned the .pdf from the web site, I can't find it. Perhaps someone else can remember where it is. It might also be in the FAQ at http://www.iiug.org > What does the logical log size based upon ? What are the > factors ? Basically, your total logical log size should cater for your largest transaction ever possible. > I want to backup the logical logs very often to avoid disaster. Very good idea. > How does informix backup logical logs ? You can use ontape -a or ontape -c if you're running OnLine 7 or tbtape -a or tbtape -c if you're using OnLine 5. HTH. -- /Ciao, \\Billy / \\Group Managing Director, The West Solutions Group: http://www.west.co.za / Chairman, South African Informix User Group: http://www.west.co.za/~saiug \\ Drivel @ http://www.west.co.za/tasteless/ / \\ "Granted, Mr Wheeler's ideas are stupid and unreasonable, but he does own the company and I / think we should go along with him..." \\________________________________________________________________________________________________