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