Generating access path reports for SQL statements that run on DB2 for z/OS

If you are using InfoSphere™ Optim™ Query Tuner for DB2® for z/OS® or InfoSphere Optim Query Workload Tuner for DB2 for z/OS, you can generate reports that show statistics for tables that an SQL statement references, details about predicates in the statement, and statistics for the indexes that the access plan uses.

Before you begin

Procedure

To generate access path reports for an SQL statement:

  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. Click the Select What to Run button.
  4. In the Select Activities window, select the Report statistics from access plan option. Then, click OK.
  5. When the Generate Access Path Reports window appears, choose which reports to generate and the format in which to generate them. Then, click OK.

Results

The reports are displayed in the Review Access Path Reports page of the Review section. If this page does not open automatically because you selected additional options in the Select Activities window, click Open Access Path Reports under Single Query on the left side of the Review section.

Feedback