RE: Warning in message log after tuning CLEANERS

The messages should disappear if you set CLEANERS and LRUS to 127. Art Kagel has posted that those warnings are erroneously generated in some Informix versions. -----Original Message----- From: Vinod Bhansali To: informix-list@iiug.org Sent: 6/9/00 2:46 PM Subject: Warning in message log after tuning CLEANERS Hi guys, I saw the following message in message log after I modified CLEANERS from 18 to 128 and LRUS from 64 to 128 We have enough big Logical Log(640 MB) and Physical Log (40 MB) 09:36:13 WARNING! Physical Log size 0 is too small. Physical Log overflows may occur during peak activity. Recommended minimum Physical Log size is 20 times maximum concurrent user threads. 09:36:13 WARNING! Logical log layout may cause OnLine to get into a locked state. Recommended smallest logical log size is 2 times maximum concurrent user threads. 09:36:14 INFORMIX-OnLine Initialized -- Shared Memory Initialized. 09:36:14 Physical Recovery Started. 09:36:14 Physical Recovery Complete: 0 Pages Restored. 09:36:14 Logical Recovery Started. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 09:36:17 Onconfig parameter CLEANERS modified from 18 to 128. 09:36:17 Onconfig parameter LRUS modified from 64 to 128. What is the reason? After setting CLEANERS to 64 I didn't see those messages again? Thanks in advance Vinod Bhansali ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com