Physical Log

Hi, My physical log is 10000kb and number of users never exceed 350, still every time I bounce the database, I get this message after few hours of recycle: WARNING! Physical Log size 10000 is too small. Physical Log overflows may occur during peak activity. Recommended minimum Physical Log size is 20 times maximum concurrent user threads. I used to get this message when my physical log size was 6000kb. Now I bumped it to 10000kb.I am still getting this message and the subject line of the alert that I get is: Dynamic Server Initialization Failure which sounds very scary especially when there are quite a few people on the list. I guess my question is how much should this physical log be in size so we dont' get this error from online log. Thanks, Sunita

I have a server about the same size. My $ONCONFIG, PHYSFILE 78000. This seems to work fine. Check points are Ok and not too frequent. No errors at boot time. IDS 9.4.FC7 on HPUX 11i

My server (IDS 10.00.UC4 / RedHat AS 3) shows about 120 sessions (from 'onstat -g ses') and we have PHYSFILE set at 100000 and LOGSIZE is 35000. We don't get the warning for Physical Log. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of RALPH GENTRY Sent: Friday, March 21, 2008 1:49 PM To: ids@iiug.org Subject: Re: Physical Log [11689] I have a server about the same size. My $ONCONFIG, PHYSFILE 78000. This seems to work fine. Check points are Ok and not too frequent. No errors at boot time. IDS 9.4.FC7 on HPUX 11i ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!