News
Abstract
The SQL Query Engine (SQE) is enhanced to be a better fit for the intended use of query parallelism.
By default, SQE will avoid using parallelism for queries that complete processing within 60 seconds. If the query execution continues beyond 60 seconds, SQE might replace the current plan with a parallel query implementation.
The PARALLEL_MIN_TIME QAQQINI control provides Db2 for i users to adjust the 60 second control higher or lower.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Database Engineer (DBE) Enhancements > New QAQQINI control PARALLEL_MIN_TIME
For complete detail, visit this IBM Documentation page: QAQQINI query options
[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;7.5.0;and future releases"}]
Was this topic helpful?
Document Information
Modified date:
11 October 2022
UID
ibm16828325