Problems runing informix se on sco open server

Posted in 2004

=?iso-8859-1?Q?=C1lvaro_Prieto?= — Wed, 2 Jun 2004 10:44:26 +0200 — source: Usenet: comp.databases.informix

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? Thanks in advance ---------------------------------------- Mi Bandeja de entrada es protegida por SPAMfighter 62 hasta ahora los spam correos que han sido bloqueados. 'Descargado libremente www.spamfighter.com (gratis) hoy! sending to informix-list

↪ replying to =?iso-8859-1?Q?=C1lvaro_Prieto?=

David Williams — Wed, 2 Jun 2004 22:28:45 +0100 — source: Usenet: comp.databases.informix

"'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! > Thanks in advance > > > ---------------------------------------- > Mi Bandeja de entrada es protegida por SPAMfighter > 62 hasta ahora los spam correos que han sido bloqueados. > 'Descargado libremente www.spamfighter.com (gratis) hoy! > > sending to informix-list