Re: New Server- How to Optimise

From: "Kirk Davis" <kirk@kirkdavis.co.uk> > >We have just upgraded our Informix Dynamic Server 7.3 hardware to a 4 * >550mhz Xeon with 1024mb RAM.. The platform was previously a single 200mhz >Pentium wth 256mb RAM. > >We have now imported the database. What is the next step to optimise the >system?? UPDATE STATISTICS And NUMCPUVPS 3 MULTIPROCESSOR 1 SINGLE_CPU_VP 0 More BUFFERS. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Thanks, will give that a go, > NUMCPUVPS 3 > MULTIPROCESSOR 1 > SINGLE_CPU_VP 0 Are these in the informix.conf file?? Where do I increase the buffer? and what to? Obnoxio The Clown <obnoxio@hotmail.com> wrote in message news:8iqbps$f1j$1@news.xmission.com... > > From: "Kirk Davis" <kirk@kirkdavis.co.uk> > > > >We have just upgraded our Informix Dynamic Server 7.3 hardware to a 4 * > >550mhz Xeon with 1024mb RAM.. The platform was previously a single 200mhz > >Pentium wth 256mb RAM. > > > >We have now imported the database. What is the next step to optimise the > >system?? > > UPDATE STATISTICS> > And > > NUMCPUVPS 3 > MULTIPROCESSOR 1 > SINGLE_CPU_VP 0> > More BUFFERS. > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com >

Kirk Davis wrote: > > Thanks, will give that a go, > > > NUMCPUVPS 3 > > MULTIPROCESSOR 1 > > SINGLE_CPU_VP 0> > Are these in the informix.conf file?? Whatever you called your ONCONFIG file. > Where do I increase the buffer? and what to? Check the BUFFERS parameter in the ONCONFIG file and bounce the server. What to set it to? Ideally large enough to hold every row you will ever need to see in memory at the same time. Practically BIG. Informix recommends for a server that has to share its host with other apps use 20-25% of memory for BUFFERS, in your case that would be 125000 under UNIX or 62500 under NT. If the host is dedicated to Informix ONLY tune the OS to minimize system buffer cache usage and go for 50% of memory or more! Art S. Kagel > Obnoxio The Clown <obnoxio@hotmail.com> wrote in message > news:8iqbps$f1j$1@news.xmission.com... > > > > From: "Kirk Davis" <kirk@kirkdavis.co.uk> > > > > > >We have just upgraded our Informix Dynamic Server 7.3 hardware to a 4 * > > >550mhz Xeon with 1024mb RAM.. The platform was previously a single 200mhz > > >Pentium wth 256mb RAM. > > > > > >We have now imported the database. What is the next step to optimise the > > >system?? > > > > UPDATE STATISTICS> > > > And > > > > NUMCPUVPS 3 > > MULTIPROCESSOR 1 > > SINGLE_CPU_VP 0> > > > More BUFFERS. > > ________________________________________________________________________ > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > >