Create a Detailed SQL Performance Monitor

To create a Detailed SQL Performance Monitor, do the following:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases and the database that you want to work with.
  3. Right-click SQL Performance Monitor and select New -> SQL Performance monitor.
  4. To create a detailed monitor, select Detailed in the Type field.

The performance monitor starts and runs until it is ended.

To monitor a specific job or query, start your job now, if it is not already running. When the job or query is ended or you have gathered enough data on it, you can Analyze the results or Run a Visual Explain. You do not have to pause or end the detailed monitor in order to use the data it has gathered, but, if you are done gathering data, you can End the monitor . However, once you end the monitor, you cannot restart it.

Note: You need job control authority and read authority to the QUSRSYS schema to use the performance monitor.

For more information, see Using System i Navigator with detailed monitors in the Database Performance and Query Optimization topic in the Information CenterLink to Information center.