FW: HP-UX 10.20 , Informix 7.30 - advice needed

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_000_01BEA429.9E5855DA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit ****** Message from InterScan E-Mail VirusWall NT ****** ** No virus found in attached file ATT29176.txt ** No virus found in attached file onconfig.tmp Mail Scanned For Virus At ITLInfosys ***************** End of message *************** ------_=_NextPart_000_01BEA429.9E5855DA Content-Type: text/plain Hi, Thanks a lot for the reply. Please see my comments in []. Vasudev ----------------------------------- Is informix and this particular app (A1) the only things running on the box? [No, this is a testing machine. Our developers use it for doing system testing of the apps they work on. We have about 45 apps that we maintain and at any given time, there could be between 2 to 5 to 8 apps being tested. We don't have the luxury of dedicating a machine for testing each app. Even this app, A1, needs the app A2 mentioned earlier, to run, since A2 gives input to A1 on the queue.] If so increase the amount of memory that you have allocated to informix. How are things laid out on disk? A root chunk of 488 MB is rather large (please tell me that you have moved logical logs to other spaces -- [No, they are all on the root dbspace rootdb7 :( I guess this is the first thing to be done.] I KNOW you didn't move the physical from the config file). Also, ~95% wio indicates disk as your bottleneck. [Yes.] Are you running KAIO? [No.] If not what does len & maxlen show in onstat -g ioq? [Can't test it right now (systems down for mnt), will do soby mid next week and post] I appears that when you have the engine running that you start with about 15 MB of memory allocated. Allocated what you can to informix and use the following (starting) guidelines for allocated the memory to the engine: if mostly OLTP: 75% to BUFFERS 25% to SHMVIRTSIZE if mostly DSS: 25% to BUFFERS 75% to SHMVIRTSIZE 90% of SHMVIRTSIZE to DS_TOTAL_MEMORY [Can you please explain the logic behind the above numbers for BUFFERS/SHMVIRTSIZE & OLTP/DSS ?] TUNE ( ADJUST ) FROM THERE. Hope this helps some continue to post and I'm sure you'll get more responses. Eric P. Melillo > -----Original Message----- > From: Eric_Melillo@agsea.com [SMTP:Eric_Melillo@agsea.com] > Sent: Friday, May 21, 1999 8:03 PM > To: RVASUDEV@inf.com > Cc: informix-list@iiug.org > Subject: RE: HP-UX 10.20 , Informix 7.30 - advice needed > > > ****** Message from InterScan E-Mail VirusWall NT ****** > > ** No virus found in attached file onconfig.tmp > > Mail Scanned For Virus At ITLInfosys > > ***************** End of message *************** > <<ATT29176.txt>> <<onconfig.tmp>> ------_=_NextPart_000_01BEA429.9E5855DA Content-Type: text/plain; name="ATT29176.txt" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="ATT29176.txt" Is informix and this particular app (A1) the only things running on the box? If so increase the amount of memory that you have allocated to = informix. How are things laid out on disk? A root chunk of 488 MB is rather = large (please tell me that you have moved logical logs to other spaces -- I KNOW you didn't move the physical from the config file). Also, ~95% = wio indicates disk as your bottleneck. Are you running KAIO? If not what does len & maxlen show in onstat -g = ioq? I appears that when you have the engine running that you start with = about 15 MB of memory allocated. Allocated what you can to informix and use the following (starting) guidelines for allocated the memory to the = engine: if mostly OLTP: 75% to BUFFERS 25% to SHMVIRTSIZE if mostly DSS: 25% to BUFFERS 75% to SHMVIRTSIZE 90% of SHMVIRTSIZE to DS_TOTAL_MEMORY TUNE ( ADJUST ) FROM THERE. Hope this helps some continue to post and I'm sure you'll get more responses. Eric P. Melillo [RVASUDEV] The reason I didn't post specifics initially is that it would become very long - thought it might put people off from reading it. Also, the query was partly generic in nature, i.e. about tuning HP-UX / Informix as a whole, so that all apps benefit in = performance. Is this another boner ? I'm not an expert on performance issues; do know that tuning needed will be different for OLTP / batch / DSS type of apps. This is more of a batch type of app, but with = some online features (has to keep pace with another app which gives it input - see Details below.) Different efforts are under way to improve perf. at app design level, code level, etc. My query was more = aimed at getting help on general kernel / onconfig tuning, based on our machine config of RAM, etc. - sar -d shows lot of disk usage - %busy ranging from 85 to 95 - sar -u showed very high %wio - around 95% Anyway, here goes - it's quite complicated : This app (A1) is a set of programs. The Big Picture first: It talks via MQ queues to another app (A2) (gets input from it) and also sends output to a third app (A3) (again via MQ queues). In a nutshell, this app A1 is not able to keep up with the speed at which the app A2 sends messages on the queue. So the input = queue eventually gets full. A2 does not do much work, while A1 does a lot of business logic processing + database access. This may be one reason why it's slow. But we are trying to make it at least catch up somewhat with A2. May be a futile effort :( End of big picture. Details : Some of the programs in A1 are written in ESQL/C and some in 4GL. (The ESQL/C programs are background batch jobs which do the real work. The 4GL program is basically an admin module to maintain config params of the app). They use MQ Series, via a wrapper = library which provides easier-to-use calls to MQ, as well as some more functionality. The library as well as the app was written = initially by our client. We now maintain many apps for them, of which this is one. Apparently, this app was giving performance problems from the = start, hence was never deployed. A lot of people worked on it off and on over the past several months, to improve the performance, but not much progress was made. (Most of the efforts were directed at the = code). There is also a library which enables the batch programs to run as background processes. A supervisor program is passed the program name and its config file as command line args. It starts the program as = a @@N