RE: Warning in message log after tuning CLEANERS

Put the LRUs back to 127, its not a 'real' error. Just a buglet in Informix. Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # forever www.wfsoftware.com # -----Original Message----- From: Vinod Bhansali [mailto:iiug@hotmail.com] Sent: Friday, June 09, 2000 10:47 PM To: informix-list@iiug.org 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 The contents of this e-mail are confidential to the ordinary user(s) of the mail address(es) to which it was sent and may be legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or use of it, or any part of it, in any form whatsoever, and any actions taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.