Use this section to find SQL statements that
you want to
tune together in a query workload or individually.
After you find the SQL statements that you want to tune,
you can right-click the list of statements and select Save
All Statements as a Workload.
After you find an
SQL statement to tune individually, you can import it into the Invoke section,
where you can run tools and advisors on it.
You can capture
SQL statements from the following types of sources.
- Text Sources
- You can capture SQL statements from files, SQL categories, and
exported workloads.
- DB2® for z/OS® Sources
- You
can capture SQL statements from these sources:
- Dynamic statement
caches
- Catalog plans, packages, or both
- QMF™
- QMF HPO
- SQL procedures
- PLAN_TABLE tables (This type of source
cannot be used for query
workloads.)
- DSN_STATEMNT_TABLE tables (This type of source
cannot be used
for query workloads.)
- DSN_FUNCTION_TABLE tables (This type
of source cannot be used
for query workloads.)
- Views, triggers, or SQL user-defined
functions (This type of
source cannot be used for query workloads.)
Outside
of the workflow assistant, you can also capture SQL statements from
the SQL and XQuery editor (though you can capture only SQL statements)
and from IBM® Optim™ Performance Manager.
For
help with capturing SQL statements, see Capturing SQL statements that you want
to analyze and tune.