End an SQL performance monitor

When you end an SQL performance monitor, you cannot start it again. If you want to be able to restart a Summary SQL Performance Monitor, you should pause the monitor instead of ending it.

To end 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 end in the right pane and select End.

The SQL performance monitor ends and, in the case of the summary monitor, saves the data that it collected. You can now Analyze the results or, if you used a detailed performance monitor, Run a Visual Explain. You can also Delete your monitor from your system if you no longer need the data, freeing the resources that it uses.

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