Re: Informix 7.14 on AIX & SCO UNIX

On 6 Aug 98 09:27:58 -0700, grammi007@classic.msn.com (Graham mitchell) wrote: >Hi there, > > I am faced with a problem regarding Informix 7.14 running on AIX > 4.1.5. This is a very old engine. You could gain a lot in performance by upgrading to 7.3 > With 8 Processors, the system is totally processor bound, as > the application is Uniface. > I cannot add more processors....There is no disk bottleneck. How much CPU time are the Uniface programs using as compared to the engine? Is the engine well tuned to utilize CPU and memory effectively? An upgrade may give you more or better tuning options as well. > What I am interested in doing is this.. > > Getting Dell Twin 400Mhz pentium machine, insatlling SCO UNIX > and running the application on the SCO machine, leaving the > RS6000 free to do just database work. > > The question is this, where will the stored procedures be executed? > If the users log onto the SCO machine, and execute the application > from there, will the stored procedures be executed on the SCO > machine or the RS6000. This is the first time I have had this > type of problem, to advice would be most welcome. If you are talking about regular database stored procedures, the kind you use the "create procedure" command in the database to create, they will be executed inside the database engine on you AIX machine whereever the user is logged in. The Uniface program can of course be executed on your SCO machine and possibly offload some execution from the AIX machine. How much that will help you is dependent on where the real bottleneck is. With our Informix 4GL programs we find that very little CPU resources are actually used by most programs. Most is used by the database. Executing the user programs on another machine requires the data to be transported over the network to that other machine. That may slow down the execution of the programs and therefore result in poor performance, particularly on batch type programs. If your Uniface programs does require a substantial amount of CPU you may gain from runing them on a separate machine. It may still be an idea to execute batch oriented programs on the AIX server. The best solution would of course be a multi tiered one, but that would proably require rewrite of the programs. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)