Creating query workloads from SQL statements that are in DB2 Query Monitor for z/OS

You can create query workloads from SQL statements that were offloaded from DB2® Query Monitor for z/OS® into DB2 tables.

Before you begin

About this task

You can capture these types of SQL statements:
  • DECLARE
  • DELETE
  • INSERT
  • INSERT INTO
  • MERGE
  • SELECT
  • UPDATE
  • VALUES
  • WITH

Procedure

To create a query workload from SQL statements in DB2 Query Monitor for z/OS:

  1. On the left side of the workflow assistant, select Query Monitor under DB2 for z/OS Sources.
    The Capture SQL from DB2 Query Monitor for z/OS page opens. If you need help with a section of this page, click the Help button for that section.
  2. Create a filter, or select an existing filter, that sets criteria for how to find the SQL statements that you want to tune.
  3. Click Capture.
  4. Right-click in the table in the Captured Statements section and select Save All Statements as a Workload.

Results

The workflow assistant for query tuning creates the query workload and lists it on the Manage and Tune Workloads page of the Manage section.

What to do next

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

Feedback