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 15         
Option  ===>                                                  Scroll ===> PAGE 
                                                                               
View Empty Intervals Y/N  Y      Show backstores availability 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                            
  --   -----     ----------------------------    ----------------------------   
  __   YES       12/05/2025 -  6:00:00.000069                           
  __   YES       12/05/2025 -  5:00:00.003916    12/05/2025 -  6:00:00.000069          
  __   YES       12/05/2025 -  4:00:00.000045    12/05/2025 -  5:00:00.003916   
  __   YES       12/05/2025 -  3:00:00.000053    12/05/2025 -  4:00:00.000045   
  __   YES       12/05/2025 -  2:00:00.126123    12/05/2025 -  3:00:00.000053   
  __   YES       12/05/2025 -  1:00:00.000062    12/05/2025 -  2:00:00.126123   
  __   YES       12/05/2025 -  0:00:00.016661    12/05/2025 -  1:00:00.000062 
  __   YES       12/04/2025 - 22:59:33.067434    12/05/2025 -  0:00:00.016661      
  __   MIGRAT    12/04/2025 - 21:59:33.525890    12/04/2025 - 22:59:33.067434   
  __   MIGRAT    12/04/2025 - 21:41:17.941277    12/04/2025 - 21:59:33.525890   
  __   MIGRAT    12/04/2025 - 21:37:16.744343    12/04/2025 - 21:41:17.941277   
  __   YES       12/04/2025 - 21:27:47.624207    12/04/2025 - 21:37:16.744343
  __   MIGRAT    12/04/2025 - 21:17:28.792976    12/04/2025 - 21:27:47.624207
  __   MIGRAT    12/04/2025 - 21:15:57.852086    12/04/2025 - 21:17:28.792976
  __   MIGRAT    12/04/2025 - 21:14:29.149265    12/04/2025 - 21:15:57.852086          
 ***************************** 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.
    • Use the Show backstores availability field to perform (Y) or skip (N) the catalog search to determine backstore availability for each interval in the Interval Selection panel.
    • Any interval that is marked as MIGRATE is 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. This line command is not allowed when a data sharing group is selected.
    R
    Release the interval. Use this line command to override the RETAIN value in CQMPARMS. This line command is not allowed when a data sharing group is selected.
    CM
    Specify 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. This line command is not allowed when a data sharing group is selected.
  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.