Running analysis tools and advisors on single SQL statements that are in query workloads that run on DB2 for z/OS

Use the Run All Single-Query Advisors and Analysis Tools page of the Invoke section to run the analysis tools and advisors on a single SQL statement that is in a query workload.

Before you begin

About this task

Procedure

To open the Run Single-Query Advisors and Analysis Tools page of the Invoke section:

Right-click the SQL statement that you want to tune and select Invoke Single-Query Advisors and Tools.

Results

The Run Single-Query Advisors and Analysis Tools page of the Invoke section opens.

What to do next

You can set options for the advisors before you run them, choose which tools and advisors to run, and generate reports. For help with these options, click the Help icon (Help), or click in a portion of the page and type F1.


Feedback