Specifying Select Statements
The Select Statement panel is where you specify the details of the Select Statements to filter records. A Select Statement consists 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)),...))
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:
- Performance and Exception Selection Criteria allow you to specify date/time ranges ("report intervals") based on transaction start, stop, or active times. Logger Selection Criteria allow you to specify report intervals based on SMF recording interval end time only.
- The Performance Select Statement panel has two views. To display the second view (showing field lengths and dictionary definitions), press F11.
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
- Inc/Exc
- Specify INC to include data records in the report or extract
if their transaction Start/Stop time is within the specified time
range.
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.
- Active/Start/Stop
- START refers
to when the transaction was attached or when processing continued
from a conversational transaction.
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.
- Report Interval
- This is used to specify
a date/time range or a time slot (times only).
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.
For a date/time range:- Either From or To can be omitted to indicate that the range is
open-ended.
If From is omitted, it defaults to the first input record.
If To is omitted, it defaults to the end of file.
- If From date is specified with no time, the start of day is assumed.
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.
- Either From or To can be omitted to indicate that the range is
open-ended.
- More +
- CICS PA allows
up to 14 report intervals in a Select Statement. You can specify the
first report interval on this panel. Enter line action S against
the first report interval to display the window where you can specify
multiple report intervals (see Figure 1).
More + is displayed at the end of the first report interval to indicate that more than one report interval has been specified.
- Inc/Exc
- Specify INC if a data record is to be included in the report
or extract when it matches the field and value specification.
Specify EXC if the data record is to be excluded from the report or extract if it matches the field and value specification.
- Field Name
- The CICS PA name
of the data field against which the record is compared. To select
one from a list of available names, press Prompt (F4) from
Field Name (see Select a field or enter
line action S (see Field selection).
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.
- Type
- Some fields require you to specify a type. For example, clock fields require either COUNT or TIME.
- Value or Range
- Enter the Field Value or Range against
which the data records are compared.
- For Character fields, specify the Field Value. The value
must not exceed the maximum field length. If the value is shorter
than the field, it is padded to the right with blanks. Scroll Right (F11)
to view the field length. The length of character type fields is commonly
8 bytes or less. However, UOWID is 6 bytes hexadecimal requiring an
entry of 12 hexadecimal characters (0-F). TSQNAME can be up to 16
characters.
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.
- For Numeric (Count and Time) fields, specify a Range.
The range can be specified as a From and To value. For example, from
1 to 100. If the To value is not specified then the From value is
assumed. Alternatively you can precede the From value with a comparison operator. For example, specify >=1 for a comparison of greater than or equal to 1. Allowed operators are:
= > >= < <=
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.
- For Character fields, specify the Field Value. The value
must not exceed the maximum field length. If the value is shorter
than the field, it is padded to the right with blanks. Scroll Right (F11)
to view the field length. The length of character type fields is commonly
8 bytes or less. However, UOWID is 6 bytes hexadecimal requiring an
entry of 12 hexadecimal characters (0-F). TSQNAME can be up to 16
characters.
- List
- The
name of an Object List in the current Object Lists data set. You can
type in the name directly or to select one from a list of available
Object Lists, place the cursor where you want the name inserted and
press Prompt (F4). See Figure 1 for
an example of the Object List selection panel. The values in the Object
List must be the same type (character or numeric) as the field for
which the Object List is specified.
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.
- Length
- The length of the field.
- Dictionary Definition (Performance Selection Criteria only)
- The description of the CMF data field in the format:
informalname owner xnnn
where:- informalname is the CMF field name
- owner is the CICS® component that 'owns' the field
- x indicates the data type:
- A - 32- or 64-bit count
- C - character string
- D - CICS PA derived time
- P - packed decimal number
- S - clock (time-count)
- T - STCK time stamp
- X - CICS PA calculated count
- nnn is the field identifier
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.
- User Field Offset and Length (Performance Selection Criteria only)
- For character user fields when only part of the field is to be
checked. Offset is the starting character position and Length is
the number of characters from this position to be checked. For example,
if the user field contains the value ABCDEFG, then specifying offset
3 and length 5 gives CDEFG. Both values are required for character
user fields and default to the entire field (offset 1 and maximum
length). CICS PA JCL generation translates these values to:
FIELDS(CHARACTER(SUBSTR(offset,length)),...)
- ⁄
- Display the menu of line actions.
- S
- Select a field name from a list (see Field selection).
- I
- Insert a field.
- R
- Repeat this row.
- C
- Copy this row.
- M
- Move this row.
- A
- Move⁄Copy after this row.
- B
- Move⁄Copy before this row.
- D
- Delete this row.