Re: Onconfig Tweak Problem

From: wyn441 <wclindenNOwcSPAM@mbf-law.com.invalid> > >"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? Yes. > >>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. Piece of advice for tuning. Your logical and physical logs should reside outside of the rootdbs. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com