Statistics processing modes

There are three different modes of display available for the statistics panels: regular mode, interval mode, and delta mode. Interval mode and delta mode determine the time over which delta values are accumulated. Deltas are not calculated in regular mode. Whenever option 2 (Display Statistics) is selected from the Online Monitor Main Menu, regular mode is activated.

To operate in either interval mode or delta mode, enter an INTERVAL or DELTA command on the command line of any statistics panel.

Statistics values are updated when:

You press Enter in any statistics panel, with the command line blank and no windows selected.
You issue an INTERVAL, DELTA, or RESET command.
You activate auto-display mode, which updates values automatically at a time interval that you specify.
Note: The auto-display function needs to be disabled before an INTERVAL, DELTA, or RESET command is issued. To stop auto-display, press the Attention key. The auto-display function can be activated again after the processing mode command is issued.

Regular processing mode

This is the default mode of operation whenever you select option 2 (Display Statistics) from the Online Monitor Main Menu. In this mode, the delta values displayed are accumulated since DB2® startup. No calculations are performed on the statistics values in this mode. You must be in interval or delta processing mode to use display exception processing. Use the RESET command to return to regular mode.

Interval processing mode

To activate interval processing mode, type INTERVAL on the command line of any statistics panel and press Enter. In interval processing mode, the delta values displayed are accumulated since the last time the INTERVAL command was entered on the command line. When interval mode is activated while viewing past data, the values are accumulated between the history time shown when the INTERVAL command was issued and the current history time.

Use interval mode to isolate DB2 statistics activity beginning at a specified time. Interval processing can help indicate the existence of a problem when running with exception processing. When you select interval processing mode, all statistics field values (except high water mark and snapshot fields) are cleared and begin the accumulation process from the start. The first values displayed after the INTERVAL command is issued represent the values from the newly-established base point to the first statistics record pair (IFCID 1 and IFCID 2) encountered after the INTERVAL command. Thereafter, the values are updated each time you press Enter. The auto-display function can be activated with interval processing mode. Statistics values are then updated automatically at the time interval that you specified. A new base point can be established by repeating the INTERVAL command.

If interval processing mode is activated, all statistics panels operate in interval mode. The time elapsed since the base point was established is displayed on the line under the heading of each statistics panel, as shown in the following figure:

Figure 1. DB2 Statistics Detail panel showing interval active Start of change

 DGOMSPSM 12:07             DB2 Statistics Detail            PMO1DLOC DSN1 V10
                                    GROUP001 MEMBER01
                                                          INTERVAL 40.088
 For details, type any character next to heading, then press Enter.

Interval mode remains active until either it is turned off or you return to the main menu. You can deactivate interval mode using the RESET or DELTA command from any statistics panel. Use the RESET command to return to regular mode.

Feedback