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.
Procedure
To capture an SQL statement by using a record
in the
PLAN_TABLE table:
- In the Data Source Explorer,
right-click the database on
which the PLAN_TABLE table is located.
- Select . The workflow assistant for query
tuning opens to the Capture section.
- On the left side of the workflow assistant, select Plan
Table under DB2 for z/OS Sources.
- Create
a filter, or select an existing one, that sets criteria for how to
find the SQL statement that you want.
- Click Run. The
records that match the criteria of the filter appear in the Matching
Records section.
- Right-click a record and select Retrieve
Query.
What to do next
If the text
of the SQL statement that corresponds to the record is in the SYSIBM.PACKAGE
table, you can run advisors and tools on the statement. If the text
of the corresponding SQL statement is not in that table, you can generate
an access plan graph and run reports.