Create a summary SQL performance monitor

To create a Summary 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 summary monitor, select Summary in the Type field.

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 will need to Save the monitor data or End the monitor. Once you end a monitor, you cannot restart it.

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