You can capture SQL
statements from SQL categories that
you created in the SQL Category view.
Procedure
To capture an SQL statement from an
SQL category:
- From the SQL Category view:
- If
the view
is not open, select , or click the SQL Category tab.
- Select the statement that you want to tune
and click Invoke
Advisors and Tools above the table.
- Select the connection profile for the DB2 database or subsystem that the SQL statement
runs against. The workflow assistant
for query tuning opens to the Run Single-Query Advisors
and Analysis Tools page of the Invoke section.
The statement appears in the Query Text field. For help with
this page, click one of the Help icons (
), or click in a portion
of the page and type F1.
- From the workflow assistant for query tuning:
- In the Data Source Explorer, right-click the database
or subsystem and select . The Capture section
of the workflow assistant for query tuning opens.
- Click SQL Category to
open the Capture
SQL from SQL Category page.
- Right-click
the statement that you want to analyze and
tune, and select Invoke Advisors and Tools. The workflow assistant
for query tuning opens to the Run Single-Query Advisors
and Analysis Tools page of the Invoke section.
The statement appears in the Query Text field. For help with
this page, click one of the Help icons (
), or click in a portion
of the page and type F1.
Results
For help with this page, click one of the
Help icons (

),
or click in a portion of the page and type F1.