Collecting EXPLAIN information about the statements in query workloads that run on DB2 for z/OS

You can collect EXPLAIN information for a query workload without also running one or more workload advisors or generating a report.

Before you begin

About this task

You can schedule an EXPLAIN task to run immediately or at some point in the future.

Procedure

To collect EXPLAIN information about the SQL statements that are in a query workload:

  1. On the Manage and Tune Workloads page, select the workload.
  2. In the More actions field, select Explain the Selected Workload. The Collect EXPLAIN Information window opens.

Results

You can either run the EXPLAIN task immediately or schedule it to take place later.

The EXPLAIN task runs in the background, so you can accomplish other tasks while it is running. To check the status of the task, select the query workload on the Show Workload Tasks page and click the Refresh button.

In some cases, the workflow assistant is not able to collect EXPLAIN data for all SQL statements in a query workload. However, you can continue to tune the query workload anyway.


Feedback