Re: Informix and Kernel Parameters

What does Sun have to say about this? SC > Greetings > > 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.) > > Thanks, > Keith