Save SQL summary monitor data (pausing a monitor)

Unlike the detailed SQL performance monitor that saves data in real time as it runs, the data that the summary SQL monitor collected is stored in memory and must be saved in order to use it.

To save a summary SQL performance monitor:

  1. In the System i Navigator window, expand the system that you want to use.
  2. Expand Databases and the database that you want to work with
  3. Click SQL Performance Monitors.
  4. If you may want to start this monitor again, right-click the monitor that you want to save and select Pause.
  5. If you do not want to start this monitor again, right-click the monitor that you want to save and select End.

The data that the monitor collected is saved.

Once you have saved your summary monitor data, you can Analyze the results, End your monitor session, or Restart your paused monitor. However, if you ended your monitor, you cannot restart it.

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