RE: Long Checkpoints

If you make your physical log too large, you may encounter the data corruption problem described in the following Tech Alert. http://www.informix.com/informix/services/ilink/alerts/082499_107840.htm The risk factoes depend on various factors, including: 1) Your Informix release level 2) Volume of database update activity 3) Frequency of level 0 backups. -----Original Message----- From: Rudy Fernandes To: informix-list@iiug.org Sent: 3/2/00 11:34 AM Subject: Re: Long Checkpoints mars1972@my-deja.com wrote: > Say you get your checkpoints down to 1 second. If the physical log > fills every 30 seconds, in a 5 minute interval, you would be locking the > database for 10 seconds total (10 checkpoints at 1 second each). If you > can get the physical log to fill at 5 minutes, the you only are going to > be locking the database for 1 second in a 5 minute interval. > > In that part, I guess I was looking at overall checkpoint waits, not > just one specific checkpoint. I see your point. In general, however, the physical log should be large enough so that it isn't even getting close to triggering checkpoints, under normal circumstances. The downside to increasing the size of the physical log is only that of space. Rudy