Capturing SQL statements from SQL procedures that are on DB2 for Linux, UNIX, and Windows

Use the Data Source Explorer to capture an SQL statement from an SQL procedure.

Before you begin

Procedure

To capture an SQL statement from an SQL procedure:

  1. In the Data Source Explorer, expand the database on which the SQL procedure is located until you find that SQL procedure.
  2. Right-click the SQL procedure and select Query Tuner > Start Tuning. The workflow assistant for query tuning opens to the Run Single-Query Advisors and Analysis Tools page of the Invoke section. The SELECT statement appears in the Query Text section.

What to do next

Run the analysis tools and the advisors.

For help, click the Help button at the top of the page. You can also press F1.


Feedback