In this example EPILOG selects for COMBINEing only those 15-minute RMF intervals where the CPU waits were greater than 20%. This means that the one hour multi-interval could be made up of zero to four real intervals. If no RMF intervals meet the criteria, nothing will be displayed for the one-hour multi-interval.
SIF and RIF can be used together in the same command, as in this example:
DISPLAY GRP(2) TODAY COMBINE(1H) SIF( CPUTIL(>20%) ) RIF( DBW(>20%) )
This example first selects any interval with a CPU wait percentage greater than 20% and combines these into one-hour multi-intervals. These multi-intervals are displayed only if database I/O waits made up more than 20% of the total thread lifetimes.
We recommend you wait to try combining SIF and RIF until you become proficient in coding exception requests, because the interactions involved in dual filtering can be confusing. multi-intervals. These multi-intervals are displayed only if database I/O waits made up more than 20% of the total thread lifetimes.
Displaying EPILOG Data