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.
Procedure
To capture an SQL statement by using a record
in the
DSN_STATEMNT_TABLE table:
- In the Data Source
Explorer, right-click the database on
which the DSN_STATEMNT_TABLE table is located.
- Select . The workflow assistant for query
tuning opens to the Capture section.
- On the left side of the editor, select Statement
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.