Warning in message log after tuning CLEANERS
Posted in 2000
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