Verify the SQL performance monitor environment

The status and properties of SQL monitors is automatically updated when you perform an action against the SQL Performance monitors from the context menu in System i Navigator. However, the status and properties can become out of date due to events outside of the context menu control. For example, if a job ends for any reason, the monitoring on the job ends. However, the information may reflect that the monitor is still running. Verify is a procedure that you can use to update your SQL performance monitor information.

To verify your SQL performance monitor information:

  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 Verify. Your SQL Performance monitor information is now verified and the information that you see is updated.