Re: What size for LOGSIZE and LOGFILES on OWS 7.22

In article <34E1EA5D.549C6141@garpac.com>, Jacob Salomon <jake@garpac.com> writes >David Williams wrote: >--- SNIP --- >> Depends, try 250K logical logs and have a few hundred of them. >> Try a physical log of 25Mb and grow it if needed. > >David, > >being a big fan of LBU_PRESERVE, I object to the very suggestion of >using small logs. I am much more in favor a a smaller number of large >logs - 25meg each or so, so that if the system freezes over [nearly] >full logs there still lots of room to rollback anything. But...logical logs don't get backed up to tape until they are complete. You could lose up to 25Mb worth of transactions!! I have the same log space as you but a better abiltity to survive disk failures. A corrupt VTOC on the disk containing the logical logs and the dbspace containing logical logs would not be accessible. I prefer to get as much on a tape as soon as possible. This also allows recovery from tape onto a second machine in case of CPU or power supply failure. Remember in the event of a real disaster you can only count on what is on tape. I would plan to have enough logspace to be able to recover and I keep the long tranasction watermarks low (30/40). A production system I run has 1000 250K logical logs i.e. 250Mb of logs. This should be enough. With Online 7 you can have up to 32767 250K logical logs i.e. 8Gb of logical logs!! -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care