RE: Problems runing informix se on sco open server

OTC Welcome back !!! Did you have a nice holiday, or has your engine been crashed :-) Keith -> -----Original Message----- -> From: Obnoxio The Clown [mailto:obnoxio@serendipita.com] -> Sent: Thursday, June 03, 2004 11:59 AM -> To: David Williams -> Cc: informix-list@iiug.org -> Subject: Re: Problems runing informix se on sco open server -> -> -> -> David Williams said: -> > -> > "'lvaro Prieto" <aprieto@sedasolubles.com> wrote in message -> > news:c9k5je$8lh$1@news.xmission.com... -> >> -> >> We are having problems running sco 5.0 and informix se, -> the platform we -> > are -> >> using is the next: -> >> -> >> hp proliant (or compaq) server, having two PIV xenon -> processor with two -> >> Gb -> >> of main memory, -> >> Equipped with an array card and three scsi disks (10000 -> rpm). We have -> >> charged all the software SCO recommends -> >> for using de second processor, and for protect them, (it -> appears to have -> >> some risk in using sco over Xenon without this patch). -> >> -> >> May every one help us on improving the efficiency of our -> system? the -> > actual -> >> velocity is absolutely unnadecuated for the machine we are using -> >> It exists some configuration or improvement method for -> the SCO or for -> >> the -> >> Informix SE? -> >> -> > -> > - Look under $INFORMIXDIR/release and check kernel -> parameters are set -> > correctly. -> > - Check how the kernel parameters affect the size of the -> buffer cache in -> > SCO. There -> > are lots of kernel tunables for the buffer cache under SCO. -> > - Use SET EXPLAIN ON in the application to see what is happening. -> > Sequential -> > scans -> > on large tables are a bad idea! -> -> Which probably means you need some indexes. -> -> -- -> -> Bye now, -> Obnoxio -> -> "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" -> - Coluche -> -> "Necrophilia means never having to say ... well, anything!" -> - Captain Pedantic -> -> "Ogni uomo mi guarda come se fossi una testa di cazzo" -> - Marco -> sending to informix-list -> ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ********************************************************************************** sending to informix-list