Generating reports that summarize recommendations and information about the current SQL statement

When you run the single-query advisors on an SQL statement, you can summarize their recommendations in a report. The report also lists information about the access path for the SQL statement and catalog information about the relevant tables, columns, and indexes.

Before you begin

Procedure

To generate a summary report:

  1. Capture the SQL statement that you want to tune. See Locations from which you can capture an SQL statement for single-query tuning.
  2. Select one of the captured statements and click the Invoke Advisors and Tools button. The Run Single-Query Advisors and Analysis Tools page in the Invoke section opens.
  3. If you need to set the schema to use for unqualified objects that the SQL statement references, or (if the statement runs on DB2 for z/OS) change the SQL ID, specify these values in the Schema and SQLID fields above the SQL statement on this page. For information about setting global defaults for schemas and SQL IDs, see Setting the schema to use for unqualified objects, the SQL ID, or both.
  4. Click the Select What to Run button.
  5. Select the types of recommendations that you want to generate.
  6. In the Select Activities window, select Summarize and report recommendations. Then, click OK.

Results

The report is generated in HTML and displayed in the Open Summary Report page of the Review section. If you want to save the report to your filesystem, click the Save Report button at the top of the report. You can also right-click the report and select the option for printing it.

Feedback