With the
workflow assistant for query tuning, you can capture
SQL statements from a number of different locations in DB2® for z/OS® or
a z/OS subsystem.
Capturing SQL statements from statement caches
Use the Capture
SQL from Statement Cache page
of the workflow assistant for query tuning to find and select an SQL
statement from the dynamic statement cache. You can then analyze the
statement, tune it, or both.
Capturing SQL statements from catalog plans or packages
Use
the Capture SQL from Catalog Plan or Package page
to find and select an SQL statement from static SQL statements that
are bound in a plan or package and stored in the DB2 catalog.
Capturing SQL statements from QMF
Use the Capture SQL from Query Management Facility page
to find and select an SQL statement from DB2 QMF™ for TSO/CICS.
Capturing SQL statements from QMF HPO
Use the Capture SQL
from Query Management Facility™ HPO page
to find and select an SQL statement from DB2 QMF HPO for TSO/CICS.
Capturing SQL statements from DB2 Query Monitor for z/OS
Use the Capture SQL from DB2 Query Monitor for
z/OS page to find and select an SQL statement to tune from SQL statements that were offloaded
from DB2 Query Monitor for z/OS into DB2 tables.
Capturing SQL statements from user-defined SQL repositories
Use
the Capture SQL from User-defined SQL Repositories page
to find and select an SQL statement from DB2 for z/OS tables that a non-IBM query-monitoring
application created. The tables must be populated with the text of
SQL statements, runtime metrics, and information about objects that
the SQL statements reference.
Capturing SQL statements by using records in the PLAN_TABLE table
Use the Capture SQL by Using Records
in the PLAN_TABLE
Table page to search the PLAN_TABLE table for a record
that is related to SQL statements that you want to tune. After you retrieve a record, you can try to retrieve
the related SQL statement from the SYSIBM.SYSPACKAGE table.
Capturing SQL statements by using records in the DSN_STATEMNT_TABLE table
Use the Capture SQL by Using Records
in the DSN_STATEMNT_TABLE
Table page to search the DSN_STATEMNT_TABLE table for a
record that is related to SQL statements that you want to tune. After you retrieve a record, you can try to retrieve
the related SQL statement from the SYSIBM.SYSPACKAGE table.