Selection Criteria
Some reports allow you to specify selection criteria to filter records based on their field values before they are passed on to report processing. This enables you to tailor your reports to include only the information that you are interested in. For example, you can specify selection criteria to restrict reports to:
- A particular date/time range
- A group of related Transaction IDs
- Transaction response times that exceed your thresholds
There are several types of selection criteria, to support the various types of record processed by CICS PA:
Type of Selection Criteria | Filters these types of record… | For these reports… | Global? |
---|---|---|---|
Performance | CMF performance (SMF 110) | All Performance reports, Transaction Resource
Usage reports Some Extracts: Cross-System Work, Record Selection |
Yes |
DB2® accounting (SMF 101) | DB2 reports (in the Subsystem Reports category) | Yes | |
WebSphere® MQ accounting (SMF 116) | WebSphere MQ reports (in the Subsystem Reports category) | Yes | |
OMEGAMON® XE for CICS® (SMF 112) | OMEGAMON reports
(in the Subsystem Reports category) Record Selection extract (in the Extracts category) |
Yes | |
Transaction Resource Usage | CMF performance (SMF 110, class 5) | Transaction Resource Usage reports | Yes |
Exception | CMF exception (SMF 110) | All Exception reports Record Selection extract (in the Extracts category) |
Yes |
Logger | System logger (SMF 88) | Logger report (in the System Reports category) Logger extract and Report Selection (in the Extracts category) |
No |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
You can specify Performance, Transaction Resource Usage, and Exception selection criteria in your report set in two places:
- Global selection criteria, which apply to all reports in the report set, except those that have their own selection criteria. Global selection criteria are accessed from the report set panel.
- Report selection criteria, which apply only to a specific report. When Report selection criteria are defined, they take precedence over the Global selection criteria. Report selection criteria are specified on the individual report panels.
You specify Logger selection criteria individually for each system report/extract in your report set.
You can also specify Performance selection criteria
in a LIST, LISTX, or SUMMARY
report form. If selection
criteria are specified in both the report and the report form it uses,
records must satisfy both criteria to be selected for the report.
For details, see Selection Criteria in Report Forms.
Statistics List and Summary reports
have
particular filtering requirements for which the standard selection
criteria mechanism is not optimal. Instead, the selection criteria
fields in the report definition use statistics alerts to implement
both record selection and alerting.
You can apply a
different alert to each report in the report set.
For details,
see Filtering Statistics List and Statistics Summary reports.
- INCLUDE only transactions that ran between 10am and 12pm, and
- INCLUDE only Transaction IDs whose names match the pattern ST*, and
- INCLUDE only transactions with a response time greater than 100 milliseconds.
For each record, the Select statements are checked one at a time until the record is either included in or excluded from report processing.
Specifying multiple Select statements provides you with a powerful facility to enhance your reporting capability. For example, suppose that you have two application systems, FINANCE and STOCK. Each system has its own performance thresholds that must be met. FINANCE transactions, prefixed by FI, must have a response time less than or equal to 100 milliseconds during peak period. STOCK transactions, prefixed by ST, must have a response time less than or equal to 200 milliseconds during peak period.
In this case, you would specify two Select statements, one for each application:
Selection criteria | Select statement | Conditions |
---|---|---|
Global or Report | FINANCE | TRAN=FI* |
STOCK | TRAN=ST* |
Each CMF Performance record is checked against the Select statements. The first Select statement for the FINANCE system is checked first. If its conditions are met, then the record is passed to report processing with no further checking. Otherwise, the second Select statement for the STOCK system is checked next. If its conditions are met, then the record is passed to report processing with no further checking. CMF records failing both Select statements bypass report processing.
For a detailed discussion and examples, see Using SELECT statements.
When you select selection criteria for the first time, you are taken directly to specify a Select statement. When you have specified at least one, a list is displayed. You can then select (edit), delete, or include/exclude any statements in the list, or add new ones.
Thus the panel flow is:
- Edit/view report set
- Selection criteria (list of Select statements)
- Select statement