FW: PDQ
This is a multi-part message in MIME format.
------=_NextPart_000_0060_01C08E29.BB8B3640
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
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_000_0060_01C08E29.BB8B3640
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D703523619-03022001>I=20
think it has to do with the type of query I run, that some queries use =
PDQ and=20
others not ........</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D703523619-03022001></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D703523619-03022001>Dirk</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B>=20
owner-informix-list@iiug.iiug.org=20
[mailto:owner-informix-list@iiug.iiug.org]<B>On Behalf Of </B>Dirk=20
Moolman<BR><B>Sent:</B> Saturday, February 03, 2001 6:18 =
PM<BR><B>To:</B>=20
informix-list<BR><B>Subject:</B> PDQ<BR><BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D256001516-03022001>Hi, I =
just ran into=20
something very strange.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D256001516-03022001></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D256001516-03022001>I am =
running to=20
queries on my system (doing my weekly maintenance =
.....)</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D256001516-03022001></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D256001516-03022001>For =
sid 27, I=20
set PDQPRIORITY=3D50, PSORT_NPROCS=3D5</SPAN></FONT></DIV><DIV><FONT face=3DArial size=3D2><SPAN class=3D256001516-03022001>For =
sid 87 I didn't=20
set anything</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D256001516-03022001></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D256001516-03022001>When I =
run "onstat=20
-g mgm", sid 87 shows as the active query and not sid 27. =
Why is=20
this, or don't I understand PDQ properly ?</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D256001516-03022001></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D256001516-03022001>Regards</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D256001516-03022001>Dirk</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><BR> </DIV>
<P><FONT face=3D"Comic Sans MS" size=3D2>Dirk Moolman</FONT> <BR><FONT=20
face=3D"Comic Sans MS" size=3D2>Database Administrator</FONT> <BR><FONT=20
face=3D"Comic Sans MS" size=3D2>Reach Technologies</FONT> </P>
<DIV> </DIV>
<DIV><FONT face=3D"Comic Sans MS" size=3D2>"People demand freedom of =
speech as a=20
compensation for the freedom of thought which they seldom =
use."</FONT></DIV>
<DIV><FONT face=3D"Comic Sans MS" size=3D2>- Kierkegaard</FONT></DIV>
<DIV> </DIV></BODY></HTML>
------=_NextPart_000_0060_01C08E29.BB8B3640--