How can I tune SQL if the features are listed as disabled because of missing EXPLAIN tables in the Advanced Configuration and Privilege Management window and in the Status section of the workflow assistant?
In the Features section of the Advanced Configuration and Privilege Management window (which you open by right-clicking a subsystem in the Data Source Explorer and selecting Analyze and Tune > Configure for Tuning > Advanced Configuration and Privilege Management) and in the Features section of the Status section of the workflow assistant, all features are indicated as being disabled. The reason given is "Missing EXPLAIN tables," as in this example.
The features are disabled for this reason when there is no set of EXPLAIN tables in a schema that matches the current SQLID. You can still tune SQL statements if you change the SQLID to one that matches the schema on a set of EXPLAIN tables.
If you are tuning single SQL statements: You can change the SQLID on the Run Single-Query Advisors and Analysis Tools page of the workflow assistant.
If you are tuning single SQL statements or query workloads: You can change the SQLID by using the Change Default SQLID and Schema window.
1. Close all open instances of the workflow assistant. For each open instance, there is a tab in the Data Studio client that looks like this:
2. In the Data Source Explorer, right-click the subsystem and select Analyze and Tune > Configure for Tuning > Change Default SQLID and Schema.
3. Specify a new default SQLID. The new default will be used for every instance of the workflow assistant that you open from this subsystem until all of your connections to the subsystem are closed.