A Performance Data Extract is created as a delimited text file for the purpose of importing the CMF performance class data into PC spreadsheet or database tools for further detailed analysis and reporting. When transferred to a workstation file the extracted performance class data is 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.
File Filter Edit Systems Options Help ------------------------------------------------------------------------------ SAMPLE - Performance Extracts Row 1 from 2 Command ===> ________________________________________________ Scroll ===> ____ ---- System Selection ----- Selection / Exc APPLID + Image + Group + Recap Form + Alert + Criteria _ CICSP001 ________ ________ EXPT0001 ________ ________ YES Output Data Set . . 'CICSP001.EXTRACT'____________________________ ------------------------------------------------------------------------------ _ DEVT____ MVS1____ ________ EXPT0002 ________ ________ NO Output Data Set . . 'DEVTMVS1.EXTRACT'____________________________ ------------------------------------------------------------------------------ ********************************* End of list ********************************
This panel displays the list of Performance Data 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 for the addition of the Form and Alert columns.
When generating the JCL, CICS PA assigns a default DDname CPAOEXnn where nn is a sequential number 01-99 to ensure uniqueness.
File Systems Options Help ------------------------------------------------------------------------------ SAMPLE - Performance Extract Command ===> _________________________________________________________________ System Selection: Extract Recap: APPLID . . CICSP001 + DDname . . . EXPT0001 Image . . ________ + Group . . ________ + Output Data Set: Data Set Name . . 'CICSP001.EXTRACT'____________________________ Disposition . . . 1 1. OLD 2. MOD (If cataloged) Extract Focus: Summary Processing Options: Form . . . . ________ + Interval . . . 00:01:00 (hh:mm:ss) Alert . . . . ________ + Override Form ________ + Severity . . ________ + Timestamp . . . ________ + Extract Format: / Include Field Labels _ Numeric Fields in Float format Delimiter . . ; Selection Criteria: Execution Options: _ Performance * / Use External Sort Repository . . : CPA.XYX.REPOSTRY F1=Help F3=Exit F4=Prompt F7=Backward F8=Forward F10=Actions F12=Cancel
Use this panel to specify extract options and record selection criteria for the Performance Data extract. The mandatory options are the name and disposition of the Extract data set and the DDname for the Recap report. You can let the other options default.
The Extract record has a default format which includes all the Clock fields. Report Forms (LIST, LISTX, or SUMMARY) can be used to tailor the format and content of the records.
The options are:
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.
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.
When generating the JCL, CICS PA assigns a default DDname CPAOEXnn where nn is a sequential number 01-99 to ensure uniqueness.
When specifying the data set name, standard TSO conventions apply.
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.
To select the name from a list of compatible Report Forms, position the cursor on the Form field and press Prompt (F4).
CICS PA JCL generation translates the Report Form specification into the LIST(FIELDS or SUMMARY(FIELDS operand.
This option only applies when a Form is specified, otherwise, it is ignored.
For the List extract, the minimum severity level selected for reporting is used to report transactions that have at least that level of reporting in any of the severity fields. This could result in transactions being reported with severity lower than the specified severity when the transaction also has one or more severity fields that meets the specified severity criteria. For example, if you specify SEVERITY(CRITICAL), only transactions with Critical severity are reported, however, if a transaction also exceeds Warning or Info thresholds, the lower severity will be also reported.
This option provides the means to filter out transactions that would never generate an alert because their resource values do not match resource values specified in the alert definition.
Specify a value in the range 00:00:01 (1 second) to 24:00:00 (24 hours). The default is 00:01:00 (1 minute).
A time interval of less than one hour must fit evenly into the hour. CICS PA will round it down to the nearest interval that aligns to the hour. For example, 1.35 is reduced to 00:01:30 minutes which will produce 40 interval report lines for each hour of data.
A time interval of more than one hour must fit evenly into the day. CICS PA will round it down to the nearest interval that aligns to the day. For example, 10.30.23 is reduced to 08:00:00 hours which will produce 3 interval report lines for each day of data.
This option generates the INTERVAL(hh:mm:ss) operand.
Blank out the field if you do not want field labels written. CICS PA JCL generation translates this to the NOLABELS operand.
Specify FLOAT format if you plan to import the extract into a DB2® table. When the DB2 Load Utility is used, it will interpret all numerical fields reliably and consistently in FLOAT format.
If FLOAT is not specified, the numeric fields are written in a mixture of integer, real and exponential using character digits. This is the default and is suitable when importing the extract data into a PC spreadsheet tool.
CICS PA JCL generation translates this to DELIMIT('delimiter'). Note that the value is enclosed in quotes in this operand.
If you specify a Report Form that also has Selection Criteria specified, CICS PA JCL generation translates the Form's Selection Criteria to the SELECT2(PERFORMANCE operand. If both the report and the Form specify Selection Criteria, then a record must pass selection by both specifications to be included in the extract.
Select / to use an external sort utility to process Summary records. This is the default. It generates the EXTERNAL(ddname) operand. This provides the DDname of the work data set used by the external sort utility. CICS PA assigns an External Work File from a pool of External Work Files with default DDnames in the format CPAXWnnn where nnn is a sequential number 001-999 to uniquely identify the work file.
An external sort should be used when processing large volumes of data.
If not selected, an internal sort is used.