RE: PDQ not used ?

Hi Bjorn. Make sure your parameter of onconfig file. DS_MAX_QUERIES # Maximum number of decision support queries DS_TOTAL_MEMORY # Decision support memory (Kbytes) If the avobe parameter is space, probably PDQ will not run. Specify DS_MAX_QUERIES and DS_TOTAL_MEMORY. HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Bjorn De Waele" <bjornREMTHIS@pandora.Be> >Reply-To: "Bjorn De Waele" <bjornREMTHIS@pandora.Be> >To: informix-list@iiug.org >Subject: PDQ not used ? >Date: Sun, 11 Jul 2004 14:24:36 GMT > >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 > > > _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail sending to informix-list

Hello, Thx a lot for your answer. I've checked it out and those queries are filled in. Do you know of any queries or dbase handling which will make the PDQ run for sure ? (Visible in active queries with onstat -g mgm) Or is it because I'm single user on a server with 2 gig of ram and shared memory set to max 1.5 gig Thx a lot, Bjorn "Tsutomu Ogiwara" <tsutomu_ogiwara@hotmail.com> wrote in message news:ccsrvt$mng$1@news.xmission.com... > > Hi Bjorn. > > Make sure your parameter of onconfig file. > DS_MAX_QUERIES # Maximum number of decision supportqueries > DS_TOTAL_MEMORY # Decision support memory (Kbytes)> > If the avobe parameter is space, probably PDQ will not run. > > Specify DS_MAX_QUERIES and DS_TOTAL_MEMORY. > > HTH. > > -- > Tsutomu Ogiwara from Tokyo Japan. > ICQ#:168106592 > > > > > > >From: "Bjorn De Waele" <bjornREMTHIS@pandora.Be> > >Reply-To: "Bjorn De Waele" <bjornREMTHIS@pandora.Be> > >To: informix-list@iiug.org > >Subject: PDQ not used ? > >Date: Sun, 11 Jul 2004 14:24:36 GMT > > > >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 > > > > > > > > _________________________________________________________________ > The new MSN 8: advanced junk mail protection and 2 months FREE* > http://join.msn.com/?page=features/junkmail > > sending to informix-list

Include SET PDQPriority 100; at the beginning of a SQL statement to make sure it runs in PDQ. You can also set environment variable for a job/account to make this setting a little more global.