RE: Informix and Kernel Parameters

I take it you've read http://www.sun.com/solutions/third-party/global/informix/pdf/InformixOLTP.pd f Paul Watson # WF Software Ltd # If its hard to code Tel: +44 1436 674729 # then it should be Fax: +44 1436 678693 # impossible to use www.wfsoftware.com # > -----Original Message----- > From: Keith L Morris [mailto:keith.l.morris@wcom.com] > Sent: Thursday, July 27, 2000 10:01 PM > To: informix-list@iiug.org > Subject: Informix and Kernel Parameters > > > 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 > The contents of this e-mail are confidential to the ordinary user(s) of the mail address(es) to which it was sent and may be legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or use of it, or any part of it, in any form whatsoever, and any actions taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.