Re: PDQ not used ?

Thanks a lot for your help ! I found my problem. I mixed some things up... I set pdqpriority=100 in my sqlstatement (embarassed...).. WinSql didn't give me an error on it. But Right now, it works great ! Thanks a lot ! Bjorn "Bjorn De Waele" <bjornREMTHIS@pandora.Be> wrote in message news:E4cIc.182360$lM.8767610@phobos.telenet-ops.be... > Hello everybody, > > > here's our Informix newbie again :) > > I'm just new in the company and nobody is a real informix specialist in our > IT-team, so I try to pull it to me. I know that I should follow a course > but we have no time for that cause the new server need to be live in 3 > weeks. So I'll take that course after it. > > Now I've read the performance guide. I've been playing around with the > onconfig. Everything goes fine ... the system has already boosted since the > initial setup. > > Right now, I lost my pdq :( If I do update statistics or run some queries, I > don't see any active query anymore in my onstat -g mgm. > In the beginning of configuration, I saw sometimes active queries overthere. > > As I read, I suppose that the pdq needs to help when running update > statistics. Or do I get the definition wrong ? > > Can anyone help me out ? I set max_pdq_priority to 100. I also set > pdqpriority 100 before running the update stats. > I'm running on W2k3. With 4 HT processors and 2 gig of ram > > Thanks a lot, > > Bjorn > > >