Creating query workloads that run on DB2 for z/OS from Optim Performance Manager

You can use to tune SQL statements that you are monitoring in Optim Performance Manager.

Before you begin

  • The client must be installed on the system where the browser that you are using for Optim™ Performance Manager is installed.
  • The DB2® database or subsystem that your SQL statements run against must be configured for query tuning.
  • The client must be running, and the data bridge server must be active. To check whether the data bridge server is active, move your cursor over the data server bridge button in the toolbar at the top of the client. Read the tooltip that appears. If the server is not running, click the button.
  • If you are capturing SQL statements from the Optim Performance Manager repository, the database or subsystem that the SQL statements run against must be enabled for monitoring.

Procedure

To create a query workload from SQL statements that you are monitoring in Optim Performance Manager, use one of these methods:

  1. To capture SQL statements from an Optim Performance Manager repository:
    1. In the workflow assistant of the client, select Optim Performance Manager Repository in the Non DB2 Sources category on the left side of the Capture section.
    2. Specify a profile to use to connect to an Optim Performance Manager repository that points to the monitored database, and a timeframe for data capture. Then, set a filter to select the SQL statements to capture.
    3. Click Capture.
  2. To invoke a tuning operation from an Optim Performance Manager dashboard:
    1. On the EI Analysis dashboard or the SQL Statements dashboard in Optim Performance Manager, select a workload to view its details.
    2. In the SQL Statements section, click Tune All.

Results

The workflow assistant query tuning lists the new query workload 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