Use this section to find an SQL statement that you want
to tune. After you find an SQL statement, 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 choose to type an SQL
statement directly into the workflow
assistant, or 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
- DSN_STATEMNT_TABLE
tables
- DSN_FUNCTION_TABLE tables
- Views, triggers,
or SQL user-defined functions
- DB2 for Linux, UNIX,
and Windows Sources
- You
can capture SQL statements from these sources:
- Packages of
static SQL statements
- SQL procedures
- Views, triggers,
or SQL user-defined functions
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