Generating and acting on recommendations for changing the access paths for SQL statements in query workloads that run on DB2 for z/OS®

The Workload Access Path Advisor examines the access plans that are chosen by the optimizer and identifies certain common access path issues.

Before you begin

Procedure

  1. In the Manage section, open the Manage and Tune Workloads page.
  2. Select the query workload and click the Invoke Advisors and Tools icon, which is on the left end of the toolbar above the list of query workloads. The Run Workload Advisors page of the Invoke section opens.
  3. Ensure that the Re-explain the query workload check box is selected, if either or both of the following conditions are true:
    • You are running this advisor after implementing recommendations from another advisor.
    • You want to collect EXPLAIN information that you can compare with EXPLAIN information taken at a different time for this query workload.
  4. Click the Select What to Run button.
  5. In the Select Activities window, select the Access paths check box and click OK. After the Workload Access Path Advisor runs, the Review Advisor Recommendations page of the Review section opens. The Summary section shows whether there are any recommendations for query revisions.
  6. In the Review Workload Advisor Recommendations page, click the Access paths tab if there are new recommendations.
  7. Specify the statements that you want to see the recommendations for and click the Show Statements icon.
  8. In the Workload Access Path Advisor Details section, select one of the statements and click the Show Query Details icon.
  9. Follow the recommendations that appear for the selected SQL statement.
  10. Follow steps 8 through 10 until all of the recommendations are implemented.

What to do next

Run the Workload Query Advisor, if you have not already done so, and then run the Workload Index Advisor.

Feedback