The Select Statement panel is where you specify the details of the Select Statements to filter records.
To display the Select Statement panel for Global Selection Criteria, enter line action S next to Performance or Exception in the Selection Criteria category on the Report Set panel. For individual Report Selection Criteria, select the report on the Report Set panel, and then enter line action S next to the Selection Criteria field. If the Selection Criteria panel is displayed, enter line action S against a particular Select Statement listed there.
The Select Statement panels are similar for Performance, Exception, and Logger Selection Criteria. The differences are:
File Edit Lists Options Help
------------------------------------------------------------------------------
SAMPLE - Performance Select Statement Row 1 of 2 More: >
Command ===> ________________________________________________ Scroll ===> PAGE
Active --------------- Report Interval ----------------
Inc Start -------- From --------- ---------- To ---------
Exc Stop DD/MM/YYYY HH:MM:SS.TH DD/MM/YYYY HH:MM:SS.TH
_ INC ACTIVE 15/01/2005 ___________ 20/01/2005 ___________
------------------------------------------------------------------------------
Inc Field ----- Value or Range -----
/ Exc Name + Type Value/From To List +
_ INC RESPONSE ______ >=3_____________ _________ ________ Milliseconds
_ INC CPU_____ COUNT_ 50______________ 1000_____ ________
******************************** End of list *********************************
F1=Help F3=Exit F4=Prompt F7=Backward F8=Forward F10=Actions
F11=Right F12=Cancel
File Edit Lists Options Help
------------------------------------------------------------------------------
SAMPLE - Performance Select Statement Row 1 of 2 More: >
Command ===> ________________________________________________ Scroll ===> PAGE
Active --------------- Report Interval ----------------
Inc Start -------- From --------- ---------- To ---------
Exc Stop DD/MM/YYYY HH:MM:SS.TH DD/MM/YYYY HH:MM:SS.TH
_ INC ACTIVE 15/01/2005 ___________ 20/01/2005 ___________
------------------------------------------------------------------------------
Inc Field - User Field -
/ Exc Name + Length Dictionary Definition Offset Length
_ INC RESPONSE 8 RESP CICSPA D901 ___ ___
_ INC CPU_____ 8 USRCPUT DFHTASK S008 ___ ___
********************************* End of list ********************************
F1=Help F3=Exit F4=Prompt F7=Backward F8=Forward F10=Actions
F11=Right F12=Cancel
You use the Select Statement panel to specify a Select Statement consisting of one or more clauses that include or exclude Report Intervals (Performance, and Exception Selection Criteria only) or Field Values (all Selection Criteria).
SELECT(PERFORMANCE|EXCEPTION(INCLUDE|EXCLUDE(
ACTIVE|START|STOP(FROM(date,time),TO(date,time))),...))
SELECT(PERFORMANCE|EXCEPTION|LOGGER(INCLUDE|EXCLUDE(
field(values)),...))
Specify EXC if data records whose transaction Start/Stop time is within the specified time range are to be excluded from the report or extract.
STOP refers to when the transaction was detached or a conversational transaction waited for terminal input.
ACTIVE refers to the entire time span between when the transaction started and stopped. Any part of the transaction active time that occurs between the specified report interval is considered a match. It can be used to make sure long-running transactions are included when their Start or Stop times fall out of the selection range.
For OMEGAMON® records, Report Interval selection is limited to the START time; the STOP and ACTIVE options are ignored.
For System Logger records, Report Interval selection is limited to the STOP time.
From and To together specify the report interval. Date is either a calendar date in your preferred format or a relative date. Time is a time-of-day. (The same edit rules apply as for Report Set Start/Stop.)
Relative dates are specified as 0, -1, -2,... to signify a date relative to the current date. 0 represents today, -1 yesterday, -2 two days ago, and so on. If both From and To dates are specified, they must be in the same format.
If From is omitted, it defaults to the first input record.
If To is omitted, it defaults to the end of file.
If To date is specified with no time, the end of day is assumed.
For a time slot, both times must be present with no dates to signify the same time slot every day. The times can span midnight.
More + is displayed on the far right to indicate that more than one report interval has been specified.
Specify EXC if the data record is to be excluded from the report or extract if it matches the field and value specification.
For the Transaction Resource Usage reports you can specify FILENAME, TSQNAME, or DPLNAME to filter the CMF transaction resource class data on File name, Temporary Storage Queue name, or distributed program link (DPL) name. FILENAME, TSQNAME, and DPLNAME are ignored for CMF performance class data.
Masking characters % (exactly one character) and * (any number of characters) are allowed. For example, specify TR* to match all values starting with TR.
To specify a null value, specify two single quotes ' ' or ''.
If you need to specify a list of values, use an Object List.
= > >= < <=
Specify time values in seconds (using a decimal point) or milliseconds. For example, we can request RESPONSE in the range 1.12 to 1.25 seconds or the equivalent 1120 to 1250 milliseconds. CICS PA displays Seconds or Milliseconds accordingly.
When Report Set JCL is generated, the values in the Object List are listed in the SELECT statements along with the explicitly specified values. The order in which the values are listed in the SELECT statement is the same order as they are specified in the Selection Criteria and Object List panel(s), however this order is of no consequence to CICS PA report processing.
informalname owner xnnn
Some special fields, such as APPLID and RESPONSE, are not defined in the CMF Dictionary and are given an owner of 'CICSPA'. They are either derived from the fixed section of the CMF record (for example, APPLID), or calculated from two or more other CMF fields (for example, RESPONSE).
User fields can be specified in Select Statements. However, you must specify in Global Options a CICS System that has user fields defined in its MCT. CICS PA recognizes the APPLID associated with the Select Statement, and when a row is selected (S line action), the list of field names will include the user fields at the bottom of the list.
FIELDS(CHARACTER(SUBSTR(offset,length)),...)