The query options file QAQQINI support provides the ability to dynamically modify or override the environment in which queries are executed through the CHGQRYA command and the QAQQINI file.
The query options file QAQQINI is used to set some attributes used by the Query Optimizer. For each query that is run the query option values are retrieved from the QAQQINI file in the library specified on the QRYOPTLIB parameter of the CHGQRYA CL command and used to optimize or implement the query.
Environmental attributes that you can modify through the QAQQINI file include: