You can create query workloads from static SQL statements
that are bound in a plan or package and stored in the DB2® catalog.
Procedure
To create a query workload from SQL statements in a plan
or package:
- Create a query workload
from the Capture section of the workflow assistant:
- On the left side of the workflow assistant, select Catalog
Plan or Package under DB2 for z/OS Sources. If you need help with
a section of this page, click the
button for that section.
- Create a filter, or
select an existing filter, that sets criteria for how to find the
SQL statements that you want to tune.
- Click Capture.
- Right-click in the
table in the Captured Statements section and
select Save All Statements as a Workload.
The workflow assistant
for query tuning creates the query workload and lists it on the Manage
and Tune Workloads page of the Manage section.
- To create a query
workload by using the Create Workload wizard:
- On the left side of
the workflow assistant for query tuning, click the Manage tab.
- In the Manage section
of the editor, click the
button to open
the Create Workload wizard.
- Follow the instructions
in the wizard to create the workload.