RE: HP-UX 10.20 , Informix 7.30 - advice needed
Posted in 1999
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BEA1F2.0153BC18 Content-Type: text/plain; charset="iso-8859-1" You might want to look at the NPROC and UPROC settings in the kernel. You have a 1.75 gig shared memory limit on HP-UX so you have to adjust around it. Phil Tallent SAP Administration Informix DBA (423)-510-7701 FAX (423) 510-7895 email: phil.tallent@brachs.com -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: Wednesday, May 19, 1999 5:51 AM To: RVASUDEV@inf.com; hpux-admin@dutchworks.nl; informix-list@iiug.org Subject: Re: HP-UX 10.20 , Informix 7.30 - advice needed From: RVASUDEV <RVASUDEV@inf.com> > >Platform: > > HP9000/D230 > 128 MB RAM > 60 GB disk > HP-UX 10.20 > Informix 7.30 > ESQL/C 9.15 > MQ Series 5.00 > >Does anyone have experience with performance tuning on this combo ? >Kernel params, onconfig params, other Informix tuning ? > >We have an app, using all the above, which is slow. Urgently need advice. > >Can provide more details if needed. ONCONFIG file is a good place to start. Do you know where the problem is? Disk, RAM, Swapping, CPU, long checkpoints, insufficient resources? You certainly don't have a whole lot of RAM, for a start. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com ------_=_NextPart_001_01BEA1F2.0153BC18 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: HP-UX 10.20 , Informix 7.30 - advice needed</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2 FACE=3D"Arial">You might want to look at the NPROC = and UPROC settings in the kernel. You have a 1.75 gig shared memory = limit on HP-UX so you have to adjust around it. </FONT></P> <P><U><FONT SIZE=3D2 FACE=3D"Arial">Phil Tallent </FONT></U> <BR><U><FONT SIZE=3D2 FACE=3D"Arial">SAP Administration Informix = DBA</FONT></U> <BR><U><FONT SIZE=3D2 FACE=3D"Arial">(423)-510-7701 FAX (423) = 510-7895</FONT></U> <BR><U><FONT SIZE=3D2 FACE=3D"Arial">email: = phil.tallent@brachs.com</FONT></U> </P> <BR> <BR> <UL><UL> <P><A NAME=3D"_MailData"><FONT SIZE=3D2 FACE=3D"Arial">-----Original = Message-----</FONT></A> <BR><B><FONT SIZE=3D2 FACE=3D"Arial">From: Obnoxio The = Clown [<A = HREF=3D"mailto:obnoxio@hotmail.com">mailto:obnoxio@hotmail.com</A>]</FON= T></B> <BR><B><FONT SIZE=3D2 FACE=3D"Arial">Sent: </FONT></B> <FONT = SIZE=3D2 FACE=3D"Arial">Wednesday, May 19, 1999 5:51 AM</FONT> <BR><B><FONT SIZE=3D2 = FACE=3D"Arial">To: </FONT></B> <FONT SIZE=3D2 = FACE=3D"Arial">RVASUDEV@inf.com; hpux-admin@dutchworks.nl; = informix-list@iiug.org</FONT> <BR><B><FONT SIZE=3D2 = FACE=3D"Arial">Subject: </FONT>= </B> <FONT SIZE=3D2 FACE=3D"Arial">Re: HP-UX 10.20 , Informix 7.30 - = advice needed</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">From: RVASUDEV = <RVASUDEV@inf.com></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Platform:</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> HP9000/D230</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> 128 MB RAM</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> 60 GB disk</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> HP-UX 10.20</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> Informix 7.30</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> ESQL/C 9.15</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> MQ Series 5.00</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Does anyone have experience with = performance tuning on this combo ?</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Kernel params, onconfig params, = other Informix tuning ?</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>We have an app, using all the = above, which is slow. Urgently need advice.</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Can provide more details if = needed.</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">ONCONFIG file is a good place to = start. Do you know where the problem is? </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Disk, RAM, Swapping, CPU, long = checkpoints, insufficient resources?</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">You certainly don't have a whole lot = of RAM, for a start.</FONT> </P> <BR> <P><FONT SIZE=3D2 = FACE=3D"Arial">______________________________________________________</F= ONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Get Your Private, Free Email at <A = HREF=3D"http://www.hotmail.com" = TARGET=3D"_blank">http://www.hotmail.com</A></FONT> </P> </UL></UL> </BODY> </HTML> ------_=_NextPart_001_01BEA1F2.0153BC18--