Capturing SQL statements from Optim Performance Manager

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:

What to do next

Tune a captured SQL statement by selecting it and clicking Invoke Advisors and Tools.

Feedback