Below is the standard exception format for either the REPORTIF or SELECTIF keyword:
REPORTIF( keyword1 (options (pnnq)) keyword2 (options (pnnq)) ... )
The exception keyword used to filter the display, such as database I/O waits (DBW). See Table 12: Wait Reasons—Standard Format on page 78 for a list of the exception keywords.
Used only with I/O and enqueue exceptions. See Table 7: Option Keywords for SET on page 60 for a list of available options.
Selection criteria for the exception are listed below:
greater than (default).
< less than.
nn % Examples: <10 >10% 10
Decimal number. Percent sign (optional).
Less than 10 percent. Greater than 10 percent. Greater than 10 percent.
To report on all intervals where the CPU wait time for PSB group 2 was greater than 20%, you would use the following command:
DISPLAY GRP(2) TODAY REPORTIF( CPUTIL(>20%) )
You can specify more than one filter in a single command. The following example displays all intervals where CPU wait time was greater than 20% and database I/O waits made up more than 30% of the total waits:
DISPLAY GRP(2) TODAY RIF( CPUTIL(>20%) DBW(>30%) )
To display all intervals for which no waits of a certain type recorded, prefix the exception type keyword with NO and give no numeric arguments (pnn%). For example: NOLPA is the equivalent of LPA(<0%).
The following two examples contrast RIF and SIF processing with combined intervals. If your site has 15-minute RMF intervals, you might decide to combine them into one-hour multi-intervals and display those intervals in which CPU wait time exceeds 20%:
DISPLAY GRP(2) TODAY COMBINE(1H) RIF( CPUTIL(>20%) ) RIF processing treats multi-intervals in the same way it treats single intervals.
Let’s look at the same example, this time using SIF rather than RIF exception processing:
DISPLAY GRP(2) TODAY COMBINE(1H) SIF( CPUTIL(>20%) )