Capture section

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


Feedback