Re: PDQ not used ?
Hi Bjorn.
Try the following.
% dbaccessdemo7
Execute the following sql via dbaccess
set pdqpriority 100;
select * from customer;
Another terminal
onstat -g mgm
e.g)
Here is a results of my test.
[tsutoo@bygzam ~]tsutoo731ud7% onstat -g mgm
Informix Dynamic Server Version 7.31.UD7 -- On-Line -- Up 00:01:59 --
9536 K
bytes
Memory Grant Manager (MGM)
--------------------------
MAX_PDQPRIORITY: 100
DS_MAX_QUERIES: 4096
DS_MAX_SCANS: 1048576
DS_TOTAL_MEMORY: 524288 KB
Queries: Active Ready Maximum
1 0 4096
<< BIG SNIP >>
Hope the helps.
--
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: Re: PDQ not used ?
>Date: Mon, 12 Jul 2004 05:12:21 GMT
>
>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 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
>
>
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
sending to informix-list