Filtering record ranges

Follow these steps to filter record ranges.

About this task

In addition to filtering, ranges of records may be filtered from the selected intervals using the RANGE command. The RANGE command enables users to select a start and ending numerical record range.

Notes:
  1. The RANGE command is only valid for View Current® Activity (Option 3), View Exceptions (Option 5), View DB2® Command Activity (Option 4) and their subpanels
  2. Ranges are not saved across Db2® Query Monitor sessions.

Procedure

  1. Issue the RANGE command from the View Current Activity, View Exceptions, or View DB2 Command Activity panels. The Filter Record Ranges panel displays:
    Figure 1. Filter Record Ranges panel
    CQM$RANG ------------- Filter Record Ranges ----------------------
Option  ===> _________________________________________________    
                                                                  
  Record Starting Number... 1_____________                        
  Record Ending Number..... 99999999______                        
                                                                  
  Press Enter to set record ranges or  PF3/CANCEL to exit

    The input fields that display on the Filter Record Ranges panel include:

    Record Starting Number
    Indicates the number of the record before which records will not be displayed.
    Record Ending Number
    Indicates the number of the record after which records will not be displayed.
  2. Specify the starting and ending number for the record range you want to view, and press Enter. A message displays indicating the range you specified is now set.
  3. Press PF3.