Re: Warning in message log after tuning CLEANERS
Last time as I had wrote I got following alarm :
Mon Jun 12 11:40:49 PDT 2000
Severity : 3
OnLine Initialization failure.
WARNING! Physical Log size 40960 is too small. Physical Log overflows may
occur during peak activity. Recommended minimum Physical Log size is 20
times maximum concurrent user threads.
Some related parameters are as follows :
NETTYPE ipcshm,1,64,CPU
NETTYPE soctcp,2,128,NET
PHYSFILE 40960
CLEANERS 65
LRUS 65
CKPTINTVL 300
LRU_MAX_DIRTY 3
LRU_MIN_DIRTY 1
As Art had written that change in the NETTYPE parameter can trigger this
alarm. Its true. I had changed NETTYPE parameter.
Old values for NETTYPE parameter were :
NETTYPE ipcshm,1,64,NET
NETTYPE soctcp,2,128,CPU
But still do you feel my Physical log is small. As per performance guide the
formulla for physical log is :
PHYSFILE = (connections * 20 * pagesize) / 1024
Why do I get this alarm?
Thanks in advance for all replies.
Vinod Bhansali
>From: "Mark D. Stock" <mdstock@mydas.freeserve.co.uk>
>To: "Bernstein, Rick" <rbernste@alarismed.com>
>CC: 'Vinod Bhansali ' <iiug@hotmail.com>, "'informix-list@iiug.org '"
><informix-list@iiug.org>
>Subject: Re: Warning in message log after tuning CLEANERS
>Date: Sun, 11 Jun 2000 22:55:28 +0100
>
>"Bernstein, Rick" wrote:
> >
> > 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.
>
>In fact it is the CLEANERS parameter that causes this. You can leave
>LRUS at 128 if you like, just reduce CLEANERS to 127 or ignore the
>message.
>
>Cheers,
>--
>Mark.
>
>+----------------------------------------------------------+-----------+
>| Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /|
>| http://www.informix.com http://www.informixhandbook.com |///// / //|
>| http://www.iiug.org +-----------------------------------+//// / ///|
>| |This email will self-destruct in |/// / ////|
>| |10 sec. If you received this email |// / /////|
>| |in error, sorry about the mess. |/ ////////|
>+----------------------+-----------------------------------+-----------+
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
In article <8ib6iv$a0r$1@news.xmission.com>, Vinod Bhansali
<iiug@hotmail.com> writes
>
>Last time as I had wrote I got following alarm :
>
>Mon Jun 12 11:40:49 PDT 2000
>Severity : 3
>OnLine Initialization failure.
>WARNING! Physical Log size 40960 is too small. Physical Log overflows may
>occur during peak activity. Recommended minimum Physical Log size is 20
>times maximum concurrent user threads.
>
>Some related parameters are as follows :
>NETTYPE ipcshm,1,64,CPU
>NETTYPE soctcp,2,128,NET
>PHYSFILE 40960
>CLEANERS 65
>LRUS 65
>CKPTINTVL 300
>LRU_MAX_DIRTY 3
>LRU_MIN_DIRTY 1>
>As Art had written that change in the NETTYPE parameter can trigger this
>alarm. Its true. I had changed NETTYPE parameter.
>Old values for NETTYPE parameter were :
>NETTYPE ipcshm,1,64,NET
>NETTYPE soctcp,2,128,CPU>
>But still do you feel my Physical log is small. As per performance guide the
>formulla for physical log is :
>PHYSFILE = (connections * 20 * pagesize) / 1024>
is this pagesize in bytes or k?
is the PHYSFILE in bytes or K?
Assuming pagesize is bytes, physfile is k and a 2k page size we get
p=(c*20*2048)/1024
p = 40960c/1024
p = 40c
40960 = 40c
c = 40960/40 i.e. 1024
The engine thinks you will need 1024 connections ??!!
>Why do I get this alarm?
>
>
>
>Thanks in advance for all replies.
>Vinod Bhansali
>
>
>
--
David Williams