Re: Informix and Kernel Parameters

From: Keith L Morris <keith.l.morris@wcom.com> > >This is kind of off topic... but not really. I'm trying to tune an >Informix Database engine running on a Sun "StarFire" (E10000) with 32 >cpus/ 32 Gig of memory > >Solaris 2.6.... but the kernel parameter applies to a lot of UNICES. >UNI. UNIE? > >The default bufhwm in Solaris is at 2%. (It was never set in >/etc/system) This means that 320 Meg of memory is being used as an >inode buffer. >(the name bufhwm is not what it looks like... that' old UNIX versus new >UNIX stuff.) > >Anyway, all sources I've seen say that having this set that way could >cause EXTERME RDBMS SLOWDOWN. > >Our Informix crawls like a pig through cow pies. > >The best setting appears to be fairly small... like about 8 Meg. > >Anyone have experience with this? > >(I'm not the Sysadm and shouldn't have to be worrying about stuff like >this... BUT hey..... it's a small world. I was a DBA 10 years ago.) I don't even know what bufhwm means -- could you clarify, please? If you want some help, you'll have to provide a lot more info. And as a final point, are you sure this is the problem? Sounds like it might be a case of "Kagel's Problem Misallocation"... :-) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com