PDQ

This is a multi-part message in MIME format. ------=_NextPart_000_005A_01C08E0D.B35BA2A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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_005A_01C08E0D.B35BA2A0 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 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>&nbsp;</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>&nbsp;</DIV> <DIV><FONT face=3DArial size=3D2><SPAN class=3D256001516-03022001>For = sid 27,&nbsp; 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>&nbsp;</DIV> <DIV><FONT face=3DArial size=3D2><SPAN class=3D256001516-03022001>When I = run "onstat=20 -g mgm",&nbsp; sid 87 shows as the active query and not sid 27.&nbsp; = Why is=20 this,&nbsp; or don't I understand PDQ properly ?</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D256001516-03022001></SPAN></FONT>&nbsp;</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>&nbsp;</DIV> <DIV><BR>&nbsp;</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>&nbsp;</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>&nbsp;</DIV></BODY></HTML> ------=_NextPart_000_005A_01C08E0D.B35BA2A0--

How many CPU VPs do you have? PDQPRIORITY 50 implies that the query in session 27 requires 50% of each resource, memory and CPU VPS, if it cannot get that it will wait until it can. If you only have one CPU VP then session 27 has to wait until it can run all alone in order to get 50% of the CPU VPs since a thread in a VP in non-interruptable. Art S. Kagel Dirk Moolman wrote: > > This is a multi-part message in MIME format. > > ------=_NextPart_000_005A_01C08E0D.B35BA2A0 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: 7bit > > 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_005A_01C08E0D.B35BA2A0 > 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 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>&nbsp;</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>&nbsp;</DIV> > <DIV><FONT face=3DArial size=3D2><SPAN class=3D256001516-03022001>For = > sid 27,&nbsp; 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>&nbsp;</DIV> > <DIV><FONT face=3DArial size=3D2><SPAN class=3D256001516-03022001>When I = > run "onstat=20 > -g mgm",&nbsp; sid 87 shows as the active query and not sid 27.&nbsp; = > Why is=20 > this,&nbsp; or don't I understand PDQ properly ?</SPAN></FONT></DIV> > <DIV><FONT face=3DArial size=3D2><SPAN=20 > class=3D256001516-03022001></SPAN></FONT>&nbsp;</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>&nbsp;</DIV> > <DIV><BR>&nbsp;</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>&nbsp;</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>&nbsp;</DIV></BODY></HTML> > > ------=_NextPart_000_005A_01C08E0D.B35BA2A0--