Change the attributes of your queries with the Change Query Attributes (CHGQRYA) command

 

You can modify different types of attributes of the queries that you will execute during a certain job with the Change Query Attributes (CHGQRYA) CL command, or by using the iSeries™ Navigator Change Query Attributes interface.

• Control 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 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.

• Set resource limits with the Predictive Query Governor
  The DB2 Universal Database™ for iSeries 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 iSeries. It can be used with all DB2 Universal Database for iSeries query interfaces and is not limited to use with SQL queries.

• Control 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^® UDB 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