Changing the attributes of your queries

You can modify different types of query attributes for a job with the Change Query Attributes (CHGQRYA) CL command. You can also use the System i® Navigator Change Query Attributes interface.

Controlling queries dynamically with the query options file QAQQINI
The query options file QAQQINI support provides the ability to dynamically modify or override the environment in which queries are executed. This modification is done through the Change Query Attributes (CHGQRYA) command and the QAQQINI file. The query options file QAQQINI is used to set some attributes used by the database manager.
Setting resource limits with the Predictive Query Governor
The DB2® for i Predictive Query Governor can stop the initiation of a query if the estimated run time (elapsed execution time) or estimated temporary storage for the query is excessive. The governor acts before a query is run instead of while a query is run. The governor can be used in any interactive or batch job on the system. It can be used with all DB2 for i query interfaces and is not limited to use with SQL queries.
Controlling parallel processing for queries
There are two types of parallel processing available. The first is a parallel I/O that is available at no charge. The second is DB2 Symmetric Multiprocessing, a feature that you can purchase. You can turn parallel processing on and off.

Parent topic: Optimizing query performance using query optimization tools

Related concepts:

Plan cache

Objects processed in parallel

Related information:

Change Query Attributes (CHGQRYA) command