Creating query workloads from the SQL editor

You can create a query workload from an SQL script that is open for editing in the SQL editor.

Before you begin

Procedure

To create a query workload from the SQL editor:

  1. In the workbench, open for editing an SQL script that contains more than one SQL statement.
  2. In the editor, connect to the DB2 for z/OS® subsystem that the SQL statements run against.
  3. Right-click in the editor and select Start Tuning.
  4. In the Capture SQL from SQL Editor page of the workflow assistant for query tuning, click (image of Save All Statements As a Workload button) in the toolbar above the list of captured SQL statements. The Manage and Tune Workloads page of the Manage section opens. The new workload is listed in the table on this page.

What to do next

Collect EXPLAIN information about the SQL statements that are in the query workload.

Feedback