Oninit cdi / Archive
Talk to an expert →

SE 5 tuning/optimizing on SCO

Posted in 2003

=?iso-8859-1?Q?Franz_Gr=FCtzmacher?= — — source: Usenet: comp.databases.informix

This is a multi-part message in MIME format. ------=_NextPart_000_0167_01C3A3A4.E0547020 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All I need some pointers in tuning (Optimizing) our Informix SE server. SCO Unix vers 5.0.5 Informix SE 5.08.UD1 SQL vers 4.17.UC1 RDS vers 4.17.UC1 We running a Pentium Pro with a SCSI hd and 128meg ram. Disk space 67% = used. =20 sar reports the following, when a user request a month report: 3.2v5.0.5 PentII(D)ISA 11/05/2003 =20 08:53:05 %usr %sys %wio %idle (-u) = =20 08:53:10 1 2 98 0 = =20 08:53:15 1 2 97 0 = =20 08:53:20 1 1 98 0 = =20 Average 1 2 98 0 I have tried to optimize the 4gl code and indexes to these reports and = tables. Would it help if we would install a second IDE hard disk on the=20 onboard IDE controller and use it for the database log files? I take it more ram will also help...? Any other idees?=20 Blessings from Cape Town the gateway to Africa. Franz ------=_NextPart_000_0167_01C3A3A4.E0547020 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff background=3D""> <DIV><FONT face=3DArial size=3D2>Hi All</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV> <DIV><FONT face=3DArial size=3D2>I need some pointers in tuning = (Optimizing) our=20 Informix SE server.<BR>SCO Unix vers 5.0.5<BR>Informix SE = 5.08.UD1<BR>SQL vers=20 4.17.UC1<BR>RDS vers 4.17.UC1</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV> <DIV><FONT face=3DArial size=3D2>We running a Pentium Pro with a SCSI hd = and 128meg=20 ram. Disk space 67% used.<BR>&nbsp;<BR>sar reports the following, when a = user=20 request a month report:<BR>3.2v5.0.5 PentII(D)ISA&nbsp;&nbsp;&nbsp;=20 11/05/2003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;&nbsp;=20 <BR>08:53:05&nbsp;&nbsp;&nbsp; %usr&nbsp;&nbsp;&nbsp; = %sys&nbsp;&nbsp;&nbsp;=20 %wio&nbsp;&nbsp; %idle=20 (-u)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 <BR>08:53:10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 98&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&= nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n= bsp;&nbsp;&nbsp;=20 <BR>08:53:15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 97&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&= nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n= bsp;&nbsp;&nbsp;=20 <BR>08:53:20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 98&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&= nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n= bsp;&nbsp;&nbsp;=20 <BR>Average&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 98&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV> <DIV><FONT face=3DArial size=3D2>I have tried to optimize the 4gl code = and indexes=20 to these reports and tables.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV> <DIV><FONT face=3DArial size=3D2>Would it help if we would install a = second IDE hard=20 disk on the <BR>onboard IDE controller and use it for the database log=20 files?<BR>I take it more ram will also help...? Any other idees? = </FONT></DIV> <DIV><BR><FONT face=3DArial size=3D2>Blessings from Cape Town the = gateway to=20 Africa.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Franz</FONT></DIV></BODY></HTML> ------=_NextPart_000_0167_01C3A3A4.E0547020-- sending to informix-list

Related threads