Selecting and managing intervals

An interval is a unit of time into which Db2 Query Monitor divides and stores data. Intervals have a start time, an end time, an interval number, and other information that uniquely identifies the interval.

Procedure

To select and manage intervals:

  1. When viewing activity summaries, exceptions, SQLCODES, or Db2 commands, type INTV in the command line, and press Enter.
    The Interval Selection panel lists the defined intervals.
    Figure 1. Interval Selection panel
    YYYY/MM/DD HH:MM:SS  -------- Interval Selection --------  Row 1 of 6          
Option  ===>                                                  Scroll ===> PAGE 
                                                                               
View Empty Intervals Y/N  Y                                                    
                                                                               
C:S-Select Interval,SS-Block Select Intervals,D-Datasets,K-Keep Interval,
  R-Release Interval,CM-Comment on Interval                                            
------------------------------------------------------------------------     > 
CMD   AVAIL     START                    END                   INTERVAL NUMBER 
 --   ------    ---------------------    --------------------- --------------- 
 __      YES    01/01/2015 - 13:46:18                                       86 
 __      YES    01/01/2015 - 13:41:49    01/01/2015 - 13:44:04              85 
 __      YES    01/01/2015 - 13:00:00    01/01/2015 - 13:41:28              84 
 __      YES    01/01/2015 - 12:00:00    01/01/2015 - 13:00:00              83 
 __      YES    01/01/2015 - 11:00:00    01/01/2015 - 12:00:00              82 
 __      YES    01/01/2015 - 10:00:00    01/01/2015 - 11:00:00              81 
 __      YES    01/01/2015 -  9:00:00    01/01/2015 - 10:00:00              80 
 __      YES    01/01/2015 -  8:00:00    01/01/2015 -  9:00:00              79 
 __      YES    01/01/2015 -  7:00:00    01/01/2015 -  8:00:00              78 
 __      YES    01/01/2015 -  6:42:01    01/01/2015 -  7:00:00              77 
 __      YES    01/01/2015 -  8:40:49    01/01/2015 -  9:00:01              39 
 __      YES    01/01/2015 - 18:08:05    01/01/2015 - 18:26:09              18 
 __      YES    01/01/2015 - 18:04:57    01/01/2015 - 18:08:05              17 
***************************** Bottom of Data **********************************
    Tips:
    • Use the View Empty Intervals field to display (Y) or hide (N) empty intervals on this panel. Empty intervals are those that contain no SQL calls, CPU time, Db2 commands, or exceptions.
    • Any interval that is marked as MIGRATE will be recalled to be processed.
    For information about any of the columns on this panel, see Interval Selection panel.
  2. To manage these intervals, use the following line commands:
    D
    Show the data set names and volumes for the selected interval.
    K
    Keep the interval. The interval cannot be released even if it is outside of the range set by the RETAIN parameter in CQMPARMS.
    R
    Release the interval. Use this line command to override the RETAIN value in CQMPARMS.
    Start of changeCMEnd of change
    Start of changeSpecify a comment about the interval. For example, you can enter a case number or other diagnostic information. The comment can be up to 256 characters. End of change
  3. To select one or more intervals for display, use the following line commands:
    S
    Select a single interval.
    SS
    Select multiple consecutive intervals. Type SS in the CMD field next to the first and last intervals of interest to start and end the block of intervals.

    You can select one or more individual intervals and one or more interval blocks. Then, press Enter.

    The display is updated to show activity for the interval or intervals that you selected.
  4. If you did not select any intervals for display, exit (PF3) this panel.