IDS Performance problem

Hi, 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 ? 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. Thanks for your experience

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"