Change query attributes
You can optimize your query performance by editing your QAQQINI file, allowing you to
dynamically modify or override the environment in which query are executed.
To change query attributes for a job:
- In the System i Navigator window, expand the system you want to use.
- Expand Databases
- Right-click the database that you want to work with and select Change Query Attributes.
- On the Change Query Attributes dialog, select the jobs you want to change query attributes for and click Select.
To select multiple jobs, use the Shift and CTRL key. To select the current job, click Show Current. The jobs
will appear in the Selected jobs list.
- To remove a job from the Selected jobs list, select the job and click Remove.
- Specify or select the schema that contains the query attributes table.
- Click Open Attributes.
- You can change the values by selecting the value you want to change and entering a new value.
- You can insert a new row by selecting Insert from the View menu.
- You can delete a row by selecting that row and selecting Delete from the View menu.
- When you are finished making changes to the table, select Save from the File menu.
- Close the table by selecting Exit from the File menu.
- Click OK.
For more information about changing query options, see Control queries dynamically with the query options file QAQQINI in the
Database performance and query optimization topic in the
Information Center
.