Use the Capture
SQL from SQL Procedure page
to find and select an SQL statement from an SQL stored procedure.
Procedure
To capture an SQL statement from an SQL procedure:
- In the Data Source Explorer, right-click the database on
which the SQL stored procedure is located.
- Select . The
workflow assistant for query tuning opens to the Capture section.
- On the left side of the editor, select SQL
Procedure 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 Capture. After
you capture SQL statements that match the criteria, the Captured
Statements section opens. The captured SQL statements
appear in a table in this section.
- Right-click the statement
that you want to analyze and tune, and select Invoke Advisors
and Tools.
The workflow assistant
for query tuning opens to the Run All Single-Query Advisors
and Analysis Tools page of the Invoke section.
The statement appears in the Query Text field. For
help on the Run All Single-Query Advisors and Analysis Tools page,
click the
button at the top of the page or in the two sections. You
can also click at the top of the page or in a section and then press
F1.