RE: WARNING! Physical Log size 1000 is too small

Dan, I had a similar message from a 7.10.UC1 OnLine (on HP-UX 9.04). Instead of the "...should be increased.." lines, I had "Recommended minimum Physical Log size is 20 times the concurrent user threads". Page 24-5 of the Level 7 Admin Guide discusses the size of the Physical Log. This may explain the basis of the calculation, although level 7.x servers do not have the USERTHREADS config param. I'm sorry, but I don't really understand your 2nd Question. Regards, Dave On 26 April 1996, Dan Jatnieks wrote... > > Reposting since I lost news access shortly after the first post ... > > I recently got this error message in my log file when I was doing > some testing ... > > 23:28:43 WARNING! Physical Log size 1000 is too small.> Physical Log overflows may occur during peak activity. > Physical Log size should be increased to '4800' to guard against > physical log overflows. > > 23:28:43 Onconfig parameter PHYSFILE modified from 6000 to 1000.> > > 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/ >