RE: IDS Performance problem

Hi I agree with Obnoxio Jpp :- when u do update statistics in your system ? HITEN -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: Friday, October 03, 2003 3:16 AM To: informix-list@iiug.org Subject: Re: IDS Performance problem jpp wrote: > I have performance problems with on IDS 9.30 on hpux. When i look > current sessions with onstat -g sql somme are always with status cond > wait(netnorm) and wait more than 1000 times. What is meaning for this > status ? It means it's waiting for something from the client. > When i look all waiting sessions on threads with onstat -g con, i have > always more than 100 waiting sessions with cond wait netnorm. Does it > means my instance has not good parameters to get very acceptable > performances. And is it possible to see sql orders relating to these > threads. It think this is very unlikely to be the root of your problem. When you say "performance problems", what, exactly, do you mean. > Thanks for your experience As the actress, etc. -- Ciao, The Obnoxious One "Ogni uomo mi guarda come se fossi una testa di cazzo" sending to informix-list