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.
Procedure
To create a query workload from SQL
statements that are
in a text-based file, follow one of these steps:
Open the Capture SQL from File page
in the Capture section. Use this page
to capture SQL statements from a file. After you capture
SQL statements from a file, click in
the toolbar above the list of captured statements. The workflow assistant
for query tuning opens the Manage and Tune Workloads page
of the Manage section. The new workload is
listed in the table on this page.
Click the Manage tab.
In the Manage
and Tune Workloads page of the Manage section,
click . Use the Create Workload wizard
to specify the file and to capture the SQL statements.
Note: The
second page of the wizard asks you either to accept a default name
for the source of the SQL statements or to provide a name. This name
is not the name of the file that you want to capture SQL statements
from. This name is any descriptive name that you choose to remind
you what the source of the SQL statements is.
After
the capture process finishes, the new workload is
listed in the table on the Manage and Tune Workloads page.