Re: WARNING! Physical Log size 1000 is too small

Dan Jatnieks wrote: > Can anyone tell me how Online calculates that a certain physical log > size is "too small"? What does it depend on? I would like to know > what was used to arrive at "4800". > > Another question I have is why the physical log size should be any > bigger than the number of BUFFERS -- isn't the physical log just the > unmodified copy of what is in the page buffers before either a > checkpoint or the page buffer is otherwise written to disk? > > -- > -- > dan jatnieks Siemens Rolm Communications Inc. > dan.jatnieks@siemensrolm.com http://www.siemensrolm.com/ This message is a warning...The calculation is based on the number of USERTHREADS configured in the onconfig file. I think it is something like...if the number of users * 5 > then 25% of your physical log on disk print out the error...then recommend a size where that statement isn't true. This is just a worst case kind of thing. We need to make sure that if your physical log was 75% full (we would request a checkpoint at this time) and if every user was in a critical section (prevent checkpoint and physical log stuff) if they used a certain maximum amount of space would the remaining 25% of the physical log be big enough to hold it? Physical log overflow is a bad thing. Anyway, the likelyhood of all your users in a critical section at once is pretty small...Hope this answers your questions. Jacques -- ******************************************************************** * Jacques P. Renaut "I'd dazzle you with brilliance * * Informix Advanced Support if I only had the knack..." * * email: jrenaut@informix.com #include <disclamier.h> * ********************************************************************