Re: numerous checkpoints

This is a multi-part message in MIME format. --------------827757232 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Saulius Raudys wrote: > > I don't understand reason why checkpoints occur so frequent. > From my point of view, there are not any event that initiate a checkpoint > (events described in INFORMIX-Online Dynamic Server Administrator's Guide > Version 7.1 12-52). > Could someone tell me another event, that is not described in the book. No, they are the only ones. Have you checked the size of your physical log? When it becomes 75% full it will force a checkpoint. This is the normal reason for frequent checkpoints. Hope that helps, -- --------------827757232 Content-Type: text/plain; charset=us-ascii; name="ATT_SIG.TXT" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="ATT_SIG.TXT" Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+ --------------827757232--