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:
- To capture SQL statements from an Optim Performance Manager repository:
- 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.
- 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.
- Click Capture.
- To invoke a tuning operation from an Optim Performance Manager dashboard:
- On the EI Analysis dashboard or the SQL Statements dashboard
in Optim Performance Manager,
select a workload to view its details.
- 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.