RE: IDS 10 on AIX found article.

I don't have anything nearly as specific as Kernoal, however, I do remember raising those same parameters on v9x and AIX 5.2. I too was leery of just changing things, upon tech supports request and without really understanding and testing the results. The "error" disappeared after the change though. Good luck, -D -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of kernoal.stephens@autozone.com Sent: Thursday, August 16, 2007 3:30 PM To: Eric Rowell Cc: informix-list-bounces@iiug.org; informix-list@iiug.org Subject: Re: IDS 10 on AIX found article. http://www.ibm.com/developerworks/eserver/articles/PerformanceandTuning. html "Eric Rowell" <erowell@gmail.co m> To Sent by: informix-list@iiug.org informix-list-bou cc nces@iiug.org Subject Re: IDS 10 on AIX 08/16/2007 02:04 PM OK. The question I have (since we don't have the default value for our AIX kernel) is how do you test to know that the values are even close to be in the right ball park? Out side of query testing is there something that the SA can look at so I can show them it is helping? Since setting the min to about 50 and the make to 100 we have not gotten the Error 12 but I am thinking there should be some performance gain to increasing it to a larger value... Eric On 8/16/07, david@smooth1.co.uk <david@smooth1.co.uk> wrote: On 16 Aug, 17:35, kernoal.steph...@autozone.com wrote: > Thomas, > > Same goes for us. > Even on 9.40.FCX with AIX. > Mostly for the instances that have a lot of chunks. > Here is what we have set, from smitty aio, and not getting the log entries > anymore. > We have seen this even with aix 4.2 and aix 4.3. > > Change/Show Characteristics of Asynchronous I/O > > Type or select values in entry fields. > Press Enter AFTER making all desired changes. > > [Entry Fields] > MINIMUM number of servers [400] > # > MAXIMUM number of servers per cpu [800] > # > maximum number of REQUESTS [12288] > # > server PRIORITY [20] > # > STATE to be configured at system restart available > + > State of fast path enable > + > Make number of requests 12288? That nothing. We use something like 600000 on Linux. Two Oracle benchmarks I saw on Linux used max number of outstanding requests as 1 million and 5 million! David. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list _____________________________________________________________________________________ The information contained in this email may be confidential and/or legally privileged. It has been sent for the sole use of the intended recipient(s). If the reader of this message is not an intended recipient, you are hereby notified that any unauthorized review, use, disclosure, dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please contact the sender by reply email and destroy all copies of the original message. To contact our email administrator directly, send to postmaster@dlapiper.com Thank you. _____________________________________________________________________________________