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).

CICS PA JCL generation translates the Report Intervals into operands with the format:
SELECT(PERFORMANCE|EXCEPTION(INCLUDE|EXCLUDE(
       ACTIVE|START|STOP(FROM(date,time),TO(date,time))),...))
The Field Values translate to:
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:

Figure 1. Performance Select Statement panel - default view and second view
   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
The options for the Report Intervals are:
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.

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.

The options for the Field Values are:
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.

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)),...)
Line Actions (field rows): The valid line actions for the Field Value rows are:
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.

Information Information

Feedback


Timestamp icon Last updated: Thursday, 7 November 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//users-guide/pselstatement.htm