You can tune SQL statements that you are monitoring in Optim Performance Manager.
Before you begin
- The InfoSphere Optim™ Query Tuner 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 InfoSphere Optim Query Tuner 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 InfoSphere Optim Query Tuner 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 capture an SQL statement from Optim Performance Manager,
use one of these methods:
- To capture an SQL statement from an Optim Performance Manager repository:
- In the workflow assistant of the InfoSphere Optim Query Tuner 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 statement to capture.
- Click Capture.
- To invoke a tuning operation from an Optim Performance Manager dashboard:
- On the Active SQL dashboard, Locking dashboard, EI Analysis
dashboard, or the SQL Statements dashboard in Optim Performance Manager,
select an SQL statement.
- Click Tune.
What to do next
Tune a captured SQL statement by selecting it and clicking
Invoke
Advisors and Tools.