You can use Optim™ Query
Workload Tuner to tune SQL statements that you are monitoring in Optim Performance Manager.
Before you begin
- The client,
Data Studio IDE, or Data Studio stand-alone 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,
Data Studio IDE, or Data Studio stand-alone must be running and the
data bridge server must be active. To check whether the data bridge
server is active, move your cursor over this button in the toolbar
at the top of the client:
.
Read the tooltip that appears. If the server is not running, click
the button.
Procedure
To create a query workload from SQL statements that you
are monitoring in Optim Performance
Manager:
- On the Extended Insight Analysis Dashboard in Optim Performance Manager, double-click a workload
to view details for that workload.
- 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.