In the Data Source Explorer, connect to the DB2 subsystem,
if the connection is not already open.
In the Data Source Explorer, right-click the DB2 subsystem
and select Query Tuner > Start Tuning.
About this task
A dynamic statement cache captures all dynamic SQL and performance
data when IFCID 0318 is enabled.
Procedure
To create a query workload from SQL statements in a dynamic
statement cache:
Create a query workload
from the Capture section of the workflow assistant:
On the left side of the workflow assistant, select Statement
Cache 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.