Re: Recommendations for QQRYDEGREE

When I make a recommendation I back it up. Why are they suggesting turning it off? There's more to the story.


Steve Pitcher
iTech Solutions
Office: (203) 744-7854 Ext. 176
Mobile: (902) 301-0810
http://www.itechsol.com<https://west.exch026.serverdata.net/owa/redir.aspx?C=JBgOIlc4Bi12Yk9kXxfyMfoRkA8OdpmbMNZqwQYygIUA02R-cmHUCA..&URL=http%3a%2f%2fwww.itechsol.com%2f>
http://www.iInTheCloud.com<https://west.exch026.serverdata.net/owa/redir.aspx?C=QqlLNfAiLvPEecQsQ7mjdj0emj6eoUlob7-8WybvF00A02R-cmHUCA..&URL=http%3a%2f%2fwww.iInTheCloud.com>
________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Rob Berendt <rob@xxxxxxxxx>
Sent: Friday, February 7, 2020 10:44:51 AM
To: Midrange Systems Technical Discussion
Subject: Recommendations for QQRYDEGREE

Currently we have system value QQRYDEGREE set to *OPTIMIZE. A recent performance evaluation by IBM Lab Services recommended that we have that set to *NONE or *IO.

We do have this installed:
5770SS1 26 5107 DB2 Symmetric Multiprocessing

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com