Restart a summary SQL performance monitor

Starting an SQL performance monitor causes it to collect and store SQL performance data in a schema that was specified when the monitor was created. The summary SQL performance monitors start automatically when you create them, but you may still need to start a monitor if it has been paused.

To start an SQL performance monitor:

  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. Click SQL Performance Monitor.
  4. Right-click the monitor you want to start in the right pane and select Continue. The Performance monitor restarts.

You can now Save the monitor data or End your monitor.

Notes:

When you start a paused monitor, the data that it collects appends to the data that was already collected. If the performance data exceeds the file size limit, the monitor continues collecting data at the beginning of the file, overwriting previous data. However, each collection period of monitoring between pauses is differentiated. You can choose which collection period you want to view.

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