Using iSeries Navigator with detailed monitors

 

You can work with detailed monitors from the iSeries™ Navigator interface. The detailed SQL performance monitor is the iSeries Navigator version of the STRDBMON database monitor, found on the native interface.

You can start this monitor by right-clicking SQL Performance Monitors under the Database portion of the iSeries Navigator tree and selecting New > Monitor. This monitor save detailed data in real time to a hard disk and does not need to be paused or ended in order to analyze the results. You can also choose to run a Visual Explain based on the data gather by the monitor. Since this monitor does save data in real time, it may have a performance impact on your system.

• Starting a detailed monitor
  You can start a detailed monitor from the iSeries Navigator interface.

• Analyze detailed monitor data
  SQL Performance monitors provides several predefined reports that you can use to analyze your monitor data.

• Comparing monitor data
  You can use iSeries Navigator to compare data sets in two different monitors.

• Viewing statements in a monitor
  You can view SQL statements that are included in a detailed monitor.

• Importing a monitor
  You can import monitor data that has been collected using Start Database Monitor (STRDBMON) command or some other interface by using iSeries Navigator.

 

Parent topic:

Optimizing query performance using query optimization tools