*OPTIMIZE will NOT give the maximum resources available. It is the most reasonable setting to achieve SMP. Setting it to *MAX will use all available memory in a job's memory pool to fulfill a task. Setting it to *NONE or *IO means the system will not use SMP at a global level.
Every system is different. Turn it to *IO and look at your performance data for a 24 hour period afterward. Notice any changes? Better, worse or negligible...you need to make an informed decision based on the data available. It's called tuning for a reason...you gotta, well, tune it. 😉
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: Monday, February 10, 2020 7:20:16 AM
To: Midrange Systems Technical Discussion
Subject: RE: Recommendations for QQRYDEGREE
<snip>
QQRYDEGREE - Query optimization degree set to *OPTIMIZE. This will give the maximum available resources to fullfil an SQL request through the SQL optimizer. This can have a significant Impanct upon system performance during this period, and is not recommended.
The recommended setting is *NONE, or *IO. This means the optimizer will tune the SQL request to the database, without consuming excessive amount of CPU. Use the QAQQINI file and CHGQRYA to fine tune, and set the query degree for business critical SQL requests.
</snip>
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
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Steve Pitcher
Sent: Friday, February 7, 2020 3:54 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Recommendations for QQRYDEGREE
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
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
--
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
--
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
midrange.com
