You can tune SQL statements that you are
monitoring in Optim™ Performance
Manager.
Before you begin
- The Optim Query Tuner 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 Optim Query Tuner 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 capture
an SQL statement from Optim Performance
Manager:
In Optim Performance
Manager, select the SQL statement and click the Tune button.
This button is located in several locations, such as the Active
SQL dashboard, the Locking dashboard,
and reports. Refer to the documentation for Optim Performance Manager for details. The workflow assistant for query tuning opens to the
Run
All Single-Query Advisors and Analysis Tools page of the
Invoke section.
The SQL statement appears in the
Query Text field.
Run
advisors and tools on the statement. For help on the Run
Single-Query Advisors and Analysis Tools page, click the
button
at the top of the page or in the two sections. You can also click
at the top of the page or in a section and then press F1.