RE: PDQ
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C09058.C3BD1BEA
Content-Type: text/plain;
charset="iso-8859-1"
PDQ is a resource. If there is insufficient of that resource to run your
query, your query is gated. Meanwhile the other fellow didn't want any PDQ,
therefore he isn't gated.
cheers
j.
-----Original Message-----
From: Dirk Moolman [mailto:dirkm@reach.co.za]
Sent: Saturday, February 03, 2001 2:39 PM
To: informix-list
Subject: FW: PDQ
I think it has to do with the type of query I run, that some queries use PDQ
and others not ........
Dirk
-----Original Message-----
From: owner-informix-list@iiug.iiug.org
[mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Dirk Moolman
Sent: Saturday, February 03, 2001 6:18 PM
To: informix-list
Subject: PDQ
Hi, I just ran into something very strange.
I am running to queries on my system (doing my weekly maintenance .....)
For sid 27, I set PDQPRIORITY=50, PSORT_NPROCS=5
For sid 87 I didn't set anything
When I run "onstat -g mgm", sid 87 shows as the active query and not sid
27. Why is this, or don't I understand PDQ properly ?
Regards
Dirk
Dirk Moolman
Database Administrator
Reach Technologies
"People demand freedom of speech as a compensation for the freedom of
thought which they seldom use."
- Kierkegaard
------_=_NextPart_001_01C09058.C3BD1BEA
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=522282116-06022001><FONT face=Arial color=#0000ff size=2>PDQ is
a resource. If there is insufficient of that resource to run your query,
your query is gated. Meanwhile the other fellow didn't want any PDQ,
therefore he isn't gated.</FONT></SPAN></DIV>
<DIV><SPAN class=522282116-06022001><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=522282116-06022001><FONT face=Arial color=#0000ff
size=2>cheers</FONT></SPAN></DIV>
<DIV><SPAN class=522282116-06022001><FONT face=Arial color=#0000ff
size=2>j.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Dirk Moolman
[mailto:dirkm@reach.co.za]<BR><B>Sent:</B> Saturday, February 03, 2001 2:39
PM<BR><B>To:</B> informix-list<BR><B>Subject:</B> FW: PDQ<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=703523619-03022001>I
think it has to do with the type of query I run, that some queries use PDQ and
others not ........</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=703523619-03022001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=703523619-03022001>Dirk</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
owner-informix-list@iiug.iiug.org
[mailto:owner-informix-list@iiug.iiug.org]<B>On Behalf Of </B>Dirk
Moolman<BR><B>Sent:</B> Saturday, February 03, 2001 6:18 PM<BR><B>To:</B>
informix-list<BR><B>Subject:</B> PDQ<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=256001516-03022001>Hi, I just ran
into something very strange.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=256001516-03022001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=256001516-03022001>I am running to
queries on my system (doing my weekly maintenance .....)</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=256001516-03022001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=256001516-03022001>For sid 27,
I set PDQPRIORITY=50, PSORT_NPROCS=5</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=256001516-03022001>For sid 87 I
didn't set anything</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=256001516-03022001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=256001516-03022001>When I run "onstat
-g mgm", sid 87 shows as the active query and not sid 27. Why is
this, or don't I understand PDQ properly ?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=256001516-03022001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=256001516-03022001>Regards</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=256001516-03022001>Dirk</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><BR> </DIV>
<P><FONT face="Comic Sans MS" size=2>Dirk Moolman</FONT> <BR><FONT
face="Comic Sans MS" size=2>Database Administrator</FONT> <BR><FONT
face="Comic Sans MS" size=2>Reach Technologies</FONT> </P>
<DIV> </DIV>
<DIV><FONT face="Comic Sans MS" size=2>"People demand freedom of speech as a
compensation for the freedom of thought which they seldom use."</FONT></DIV>
<DIV><FONT face="Comic Sans MS" size=2>- Kierkegaard</FONT></DIV>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C09058.C3BD1BEA--