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 IBM Data Studio 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 IBM Data Studio client must be running, and the embedded HTTP server must be active. To check whether the embedded HTTP server is active, move your cursor over the embedded HTTP server button in the toolbar at the top of the IBM Data Studio 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.
  • If you are capturing SQL statements from the Optim Performance Manager repository, ensure that your user ID is authorized to access the performance metrics stored in the repository database. To be authorized, your user ID must be a member of the user group that was authorized for accessing the repository database. This authorization takes place when InfoSphere Optim Performance Manager is installed.

Procedure

To create a query workload from SQL statements that you are monitoring in Optim Performance Manager:

You can either create a query workload by using the workflow assistant in or by invoking a tuning operation from an Optim Performance Manager dashboard:

Results

The workflow assistant 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