You can use InfoSphere Optim™ Query Tuner 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 InfoSphere Optim Query Tuner or
by invoking a tuning operation from an Optim Performance Manager dashboard:- To capture SQL statements from an Optim Performance Manager repository
by using the workflow assistant in InfoSphere Optim Query Tuner:
- In the workflow assistant of the IBM® Data
Studio 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 lists the new query workload on the
Manage
and Tune Workloads page of the
Manage section.