Statistics extract

A Statistics Extract is created as a delimited text file for the purpose of importing CICS® statistics into PC spreadsheet or database tools for further detailed analysis and reporting. When transferred to a workstation file the extracted CICS statistics are available to PC applications such as Lotus® 1-2-3®.

A Recap report containing processing statistics is always printed at the end of extract processing.

To request the extract, enter line action S against the Statistics Extract on the Report Set panel. If extracts have been previously specified, the list of Statistics Extracts is displayed. Otherwise, the Statistics Extract panel is displayed for you to define your first one.

Figure 1. Statistics Extracts
File  Filter  Edit  Systems  Options  Help
 ------------------------------------------------------------------------------
                           SAMPLE - Statistics Extracts            Row 1 from 2
 Command ===> ________________________________________________ Scroll ===> ____
 
        ---- System Selection -----                          Selection
 / Exc  APPLID +  Image +  Group +    Recap
 _      CICSP001  ________ ________   STEX0001
        Output Data Set Prefix . .  'CICSP001.EXTRACT'___________________
 ------------------------------------------------------------------------------
 _      DEVT____  MVS1____ ________   STEX0002
        Output Data Set Prefix . .  'DEVTMVS1.EXTRACT'___________________
 ------------------------------------------------------------------------------
 ******************************** Bottom of data *******************************
 

This panel displays the list of Statistics Extracts in this Report Set. You can select (edit), delete, or include/exclude any extract, insert new ones, or rearrange them (move/copy).

The options and line actions are the same as on the Cross-System Work Extracts panel (see Cross-System Work extract), except that there are no selection criteria, and that, here, you specify a prefix for the output data set name, rather than the complete name.

To display the Statistics Extract panel, enter line action S against the Statistics Extract on the Report Set panel, then if the list of previously specified extracts is displayed, enter line action S against a particular extract in the list.
Figure 2. Statistics Extract
File  Systems  Options  Help
 ------------------------------------------------------------------------------
                            SAMPLE - Statistics Extract
 Command ===> _________________________________________________________________
  
 System Selection:                       Extract Recap:
  APPLID . . CICSP001  +                  DDname  . . . STEX0001
  Image  . . ________  +
  Group  . . ________  +
 
 Statistics Reports:
  _  Select to specify Statistics Reports
 
 Output Data Set:
  Data Set Name Prefix . . 'CICSP001.EXTRACT'____________________________
  Disposition  . . . . . . 1  1. OLD   2. MOD    (If cataloged)
 
 Extract Format:                         Enter "/" to select option 
  Delimiter . . ;                          Include Field Labels
 
 
 Filter Criteria:
  Type . . . . . /  EOD  /  INT  /  USS  /  REQ  /  RRT
 
  F1=Help      F3=Exit      F4=Prompt    F7=Backward  F8=Forward  F10=Actions
 F12=Cancel

Use this panel to specify extract options and interval types for the Statistics extract. The mandatory options are the prefix and disposition of the Extract data set, the DDname for the Recap report, and the selection of statistics reports that you want to extract. You can let the other options default.

The format of each extract depends on the statistics reports that you select.

The options are:

System Selection
Identifies the CICS APPLID(s) whose data you want to select for processing.

You can specify any combination of APPLID, Image, or Group, but these must be defined in your System Definitions. If you do not specify System Selection here or in the Global Options, then you are prompted at run time to specify the System Selection. This will apply globally to all reports and extracts without their own System Selection. This is recommended as it allows you to run your Report Sets against any of your defined Systems. Press the Prompt key (F4) to select from a list of defined Systems, Images, or Groups. To modify your System Definitions, select Systems in the action bar.

Specify one of the following:
  • A CICS APPLID. An APPLID that matches a defined System's name pattern is also allowed. For example, CICSP1 can be specified if CICSP* is a defined system.
  • An APPLID and an MVS™ Image. This identifies the MVS Image where your CICS system runs.
  • An MVS Image. All CICS systems executing on this MVS Image is selected.
  • An APPLID and Image combination plus a Group. This is useful for uniquely identifying a CICS system when there are multiple CICS systems with the same name defined.
  • A Group alone. CICS PA will select all CICS APPLIDs defined to the Group. For example, for transaction grouping, or for systems that connect via IRC/MRO, ISC/APPC, or IPIC.

CICS PA uses the System Selection in JCL generation to build the APPLID(applid1,applid2,applid3,...) and INput(SMFIN001,SMFIN002,SMFIN003,...) operands, and corresponding //SMFINnnn DD statements.

System Selection can also be specified either:
  • In Global Options. The report-level specification takes precedence over the global.
  • At run time. The run-time System Selection overrides the Global Options and optionally the report-level specification.
Statistics Reports
To specify the statistics reports that you want to extract, enter a non-blank character next to Select to specify Statistics Reports. A list panel of CICS statistics report titles appears. Enter line action A next to the reports that you want to extract, and then press Exit (F3). An asterisk appears next to Select to specify Statistics Reports, indicating that you have selected reports.
Output Data Set Name Prefix
The prefix for the data set names where the extract records are written. If CICS PA is to create the data set at run time, the default allocation attributes specified on the Reporting Allocation Settings panel are used in generating the JCL. If the data set is already cataloged, then CICS PA will use DISP=OLD or DISP=MOD according to your request to overwrite or append to the existing data set. When generating the JCL:
  • CICS PA fully qualifies the extract data set name by appending to this prefix STTSxxxx for CICS Transaction Server (TS) statistics or STTGxxxx for CICS Transaction Gateway (TG) statistics, where xxxx is the statistics ID.
  • CICS PA assigns the corresponding default DDname TSxxxxnn or TGxxxxnn, where nn is a 2-digit sequence number that ensures each DDname is unique.

When specifying the data set name prefix, standard TSO conventions apply.

Disposition
The DISP value that you want the generated JCL to use for the output data set if it is already cataloged:
OLD
Overwrites the data set contents with the new extract data.
MOD
Appends the new extract data.

You must specify one of these dispositions regardless of whether the output data set is cataloged. If the output data set is not cataloged when CICS PA generates the JCL, then CICS PA generates the JCL using DISP=(NEW,CATLG) to catalog it.

Delimiter
The field delimiter used to separate each data field in the extract records. The default is a semicolon (;).

CICS PA JCL generation translates this to DELIMIT('delimiter'). Note that the value is enclosed in quotes in this operand.

Include Field Labels
Select () to include field labels as the first record written to the extract data set. This is the default. CICS PA JCL generation translates this to the LABELS operand.

Blank out the field if you do not want field labels written. CICS PA JCL generation translates this to the NOLABELS operand.

Filter Criteria
To limit the types of CICS statistics intervals that CICS PA extracts, enter / next to the types you are interested in:
EOD
End-of-day
REQ
Requested
USS
Unsolicited
INT
Interval
RRT
Requested reset