Browsing, sorting, and filtering data

Browse, sort, and filter data to find and work with the SQL metrics that are most important to you.

Browsing query activity in previous and next intervals
When viewing activity summaries, exceptions, SQLCODES, or Db2® command activity, you can use the interval navigation commands to view activity in the previous or next interval. You can also navigate back to the current interval.
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.
Using filters
You can use filters to specify the type of information to display for an ISPF session.
Finding strings on a panel
In the ISPF interface, you can search for a specific string within the data displayed on a panel.
Sorting table data
On panels of scrollable or tabular data, you can sort data by a selected column. Data can be sorted in ascending or descending order.
Column display functions
Column display functions (CSETUP functions) enable you to rearrange report columns, change the width of individual columns, and control the vertical ordering of columns.
Displaying columns in list format
On a report panel, you can reformat the display of a selected line so that each column becomes a row and the values are displayed in list format.

Parent topic: Working in ISPF