Re: Logical log write volumes

Andy Kent writes:- > Can anyone tell me how you work out how much gets written to the logical > logs during an insert-intensive application? What are the differenc > here between buffered and unbuffered logging? (I thought buffered d > "piggyback" writes, but I was on a site recently where the logging mode > didn't seem to make any difference to logging volumes) > > akent@cix.compulink.co.uk (Andy Kent) > ------------------------------------------------ > Freelance Informix Database Specialist, > Redland, Bristol, England Andy, if you want to work out the contents for logical logs for a particualr transaction you can use tbcheck to get the details of the transaction. This tells you how much space in the logs are used for each component of the transaction. As to your question concerning the difference between buffered and unbuffered logging, I can't believe you had to ask. The amount of logging does not change, merely the frequency of flushing the buffer to disk. Buffered logging does leave some data vulnerable that is all. Might I recommend that you get yourself on a decent Online course! Malcolm Weallans Online Database Consultancy 2 Arkley Court Maidenhead Berks SL6 2YR Phone 0628-72154 Fax 0628-37463 CIX - onlinedbc