QQRYDEGREE on SMP AS400

[shearerj]

Does anybody have experience with QQRYDEGREE and SMP on the AS400? From what I understand it should balance a job across all the processors on an AS400.

Nobody seems to know anything about it.

Jeremy Shearer
Independent CNC Consultant
[email protected]

 

[whits]

Jeremy,
I know a little about it. Give me some specific questions, and I'll see
if I can answer them.

Whit

Whit Smith
IBM Americas Advanced Technical Support Solutions Center
Dallas, TX
Phone: 817-962-4265 Fax: 817-962-8780



shearerj
<jeremyshearer@ho To: Whit Smith/Rochester/IBM@IBMUS
tmail.com> cc:
Sent by: Subject: QQRYDEGREE on SMP AS400
owner-jdelist@jde
list.com


12/19/2001 03:11
PM
Please respond to
jdelist





Does anybody have experience with QQRYDEGREE and SMP on the AS400? From
what I understand it should balance a job across all the processors on an
AS400.

Nobody seems to know anything about it.

Jeremy Shearer
Independent CNC Consultant
[email protected]
--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat
=&Board=OW&Number=25570
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE mailing list / forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+

 

[hotm6654]

We turned it on about 1 month before go-live. We have quad processors and I can't say that I could tell that it made a difference. There is really no way to measure the kinds of things that it would improve performance on. As Rob Jump already mentioned most JDE queries are 1 table (no joins) an no subselects. I think this is one of those things that OneWorld is not configured to benefit from.

JD Nowell
OW: B7332
ES: AS400 V4R4 CO: DB2/400 SP: 11.2
Users: 250 TSE Users: 100