To create a Detailed SQL Performance Monitor, do the following:
The performance monitor starts and runs until it is ended.
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 can Analyze the results or Run a Visual Explain. You do not have to pause or end the detailed monitor in order to use the data it has gathered, but, if you are done gathering data, you can End the monitor . However, once you end the monitor, you cannot restart it.
Note: You need job control authority and read authority to the QUSRSYS schema to use the performance monitor.
For more information, see Using System i Navigator with detailed monitors in the Database Performance and Query Optimization topic in the
Information Center.