Modifying global default settings and values for tuning query workloads that run on DB2 for Linux, UNIX, and Windows

You can modify the values for a number of options that apply for every SQL statement and query workload that you tune.

About this task

Modifying these global options requires that you close all open instances of the workflow assistant for the changed values to take effect. Therefore, you should consider whether you want to modify them before you start capturing and tuning SQL statements and query workloads. You can, however, modify any of these values for individual SQL statements and query workloads before running advisors and tools.

Options exist for all of the advisors. You can also set options for how to gather EXPLAIN information for SQL statements, options for tracing, and more. You can modify global options even if you are not currently connected to a database.

Procedure

To modify values for global options:

  1. In the main menu, select Window > Preferences.
  2. In the Preferences window, expand Data Management > Query Tuner.
  3. Select the Query Tuner page or any of its subpages to see the options that you can modify.
  4. If you change values on a page, click Apply before moving to another page.
  5. After you are finished, click OK.

What to do next

If any instances of the workflow assistant are open, close them. You can save your work when you close them, and then reopen your work from the Project Explorer.


Feedback