Capture section

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.


Feedback