Comparing monitor data

 

You can use iSeries™ Navigator to compare data sets in two different monitors.

To compare data sets in different monitors, go to iSeries Navigator > system name > SQL performance monitors. Right-click a monitor in the right pane and select Compare.

On the Compare dialog, you can specify information about the data sets that you want to compare.

Name

The name of the monitors that you want to compare.

Schema mask

Select any names that you want the compare to ignore. For example, consider the following scenario: You have an application running in a test schema and have it optimized. Now you move it to the production schema and you want to compare how it executes there. The statements in the compare are identical except that the statements in the test schema use "TEST" and the statements in the production schema use "PROD". You can use the schema mask to ignore "TEST" in the first monitor and to ignore "PROD" in the second monitor so that the statements in the two monitors appear identical.

Compare statements that ran longer than

The minimum runtime for statements to be compared.

Minimum percent difference

The minimum difference in key attributes of the two statements being compared that determines if the statements are considered equal or not. For example, if you select 25% as the minimum percent different, only matching statements whose key attributes differ by 25% or more are returned.

When you click Compare, both monitors are scanned for matching statements. Any matches found will be displayed side-by-side for comparison of key attributes of each implementation.

On the Comparison output dialog, you view statements that are included in the monitor by clicking Show Statements. You can also run Visual Explain by selecting a statement and clicking Visual Explain.

 

Parent topic:

Using iSeries Navigator with detailed monitors