RE: Warning in message log after tuning CLEANERS
Posted in 2000
Topics: Performance & Tuning, Server Administration, Logging & Checkpoints
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