You can create a query workload from an SQL script that
is open for editing in the SQL editor.
Procedure
To create a query workload from the SQL editor:
- In the workbench, open for editing an SQL script that contains
more than one SQL statement.
- In the editor, connect to the DB2 for z/OS® subsystem that the SQL statements
run against.
- Right-click in the editor and select Start Tuning.
- 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.