Re: Onconfig Tweak Problem
From: wyn441 <wclindenNOwcSPAM@mbf-law.com.invalid>
>
>Informix 7.30.TC7 on WINNT Server
>
>I'm opening up here and exposing my lack of knowledge so go
>gently on me.
Tempting. Very tempting.
>I've been tweaking my onconfig file to enhance performance and
>today I see an warning error in my online log.
>"Physical Log size 20000 is too small. Physical Log overflows
>may occur during peak activity. Recommended minimum Physical Log
>size is 20 times maximum concurrent user threads."
>Ok, using onstat -u I see I have:
> 258 active, 384 total, 274 maximum concurrent
>Assuming this is where I find my maximum concurrent thread info,
>that would mean my PHYSFILE entry should be 5480 (or 5k)
>Here is my current settings.
># Physical Log Configuration
>PHYSDBS rootdbs # Location (dbspace) of physical log
>PHYSFILE 20000 # Physical log file size (Kbytes)>
>Now, nobody sucks at math more than me, so I could be wrong
>here, but isn't 20000(KBytes) larger than 5480 (bytes).
>
>Tell me where I err?
How many LRUS have you got? if 128, you might be running into an ignorable
bug.
You should move your pysical log out of the rootdbs as well.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
"Obnoxio The Clown" <obnoxio@hotmail.com> wrote:
>>I'm opening up here and exposing my lack of knowledge so go
>>gently on me.
>
>Tempting. Very tempting.
Which is tempting - going gently or not?
>>I've been tweaking my onconfig file to enhance performance and
>>today I see an warning error in my online log.
>>"Physical Log size 20000 is too small. Physical Log overflows
>>may occur during peak activity. Recommended minimum Physical
Log
>>size is 20 times maximum concurrent user threads."
>>Ok, using onstat -u I see I have:
>> 258 active, 384 total, 274 maximum concurrent
>>Assuming this is where I find my maximum concurrent thread
info,
>>that would mean my PHYSFILE entry should be 5480 (or 5k)
>>Here is my current settings.
>># Physical Log Configuration
>>PHYSDBS rootdbs # Location (dbspace) of physical log
>>PHYSFILE 20000 # Physical log file size (Kbytes)>>
>>Now, nobody sucks at math more than me, so I could be wrong
>>here, but isn't 20000(KBytes) larger than 5480 (bytes).
>>
>>Tell me where I err?
>
>How many LRUS have you got? if 128, you might be running into
an ignorable
>bug.
>
>You should move your pysical log out of the rootdbs as well.
I have 127 LRUS. Will moving the log out of rootdbs prevent the
error message or are you just passing along a piece of advice
for tuning? In either case, thanks.
-----------------------------------------------------------
Got questions? Get answers over the phone at Keen.com.
Up to 100 minutes free!
http://www.keen.com
>>>>> " " == wyn441 <wclindenNOwcSPAM@mbf-law.com.invalid> writes: > I have 127 LRUS. Will moving the log out of rootdbs prevent the > error message or are you just passing along a piece of advice > for tuning? In either case, thanks. Its a bit of advice for tuning. Its recommended that you move the physical and logical logs out of rootdbs and onto seperate spindles if possible. Mark -- "Behold! The greatest breakthrough in labor relations since the cat o' nine tails! [unveils his Frankenstein monster]" -- Montgomery Burns in `If I Only Had a Brain' in ``Treehouse of Horror II''