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.

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

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:

Information Information

Feedback


Timestamp icon Last updated: Thursday, 7 November 2013


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