Query tuning integration tips and troubleshooting

If you attempt to send SQL text to a query tuning tool for analysis and tuning but the Tune button is disabled, consider the following troubleshooting tips.

Verify the following:

  • The SQL text must be explainable. By default, Db2 Query Monitor applies a filter (referred to as the EXPLAIN filter) which prevents SQL statements that cannot be explained from being sent to the query tuner. A small fraction of SQL statements that can be explained might not pass this filter and as a result might not be sent to the query tuner. For this reason, you have the option of using the EXPLAIN filter. To turn on or off the EXPLAIN filter, select the menu option Query Tuning > Use 'EXPLAIN' Filter.
  • You must start the query workload tuner before you attempt to tune an SQL statement or workload from the CAE Browser Client.