You can create query workloads from SQL statements from DB2® QMF™ HPO
for TSO/CICS.
Procedure
To create a query workload from SQL statements in DB2 QMF HPO
for TSO/CICS:
- Create a query workload
from the Capture section of the workflow assistant:
- On the left side of the workflow assistant, select QMF
HPO 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
workloadFollow the instructions
in the wizard to create the workload.