System Logger extract
A System Logger Extract is created as a delimited text file for the purpose of importing System Logger data into PC spreadsheet tools or database tools (such as DB2®) 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 System Logger Extract on the Report Set panel. If extracts of this type have been previously specified, the list of System Logger Extracts is displayed. Otherwise, the System Logger Extract panel is displayed for you to define your first extract of this type.
File Filter Edit Systems Options Help
------------------------------------------------------------------------------
SAMPLE - System Logger Extracts Row 1 from 1
Command ===> ________________________________________________ Scroll ===> ____
---- System Selection ----- Selection
/ Exc Logger + Image + Group + Output Criteria
_ CICSP001 MVS1____ ________ LOEX0001 NO
Output Data Set . . 'CICSP001.EXTRACT'_____________________________
-------------------------------------------------------------------------------
********************************* End of list *********************************
This panel displays the list of System Logger 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 are:
- System Selection
- System Selection identifies the System Logger(s) and associated
SMF files you want to report against. Any combination of Logger, Image,
or Group can be specified but must be defined in System Definitions.
You can use Prompt (F4) to select from a list. To link directly
to System Definitions, select Systems in the action bar. Specify either:
- A Logger.
- A Logger for a particular Image. This identifies a particular System Logger when there is more than one with the same ID.
- An Image. CICS PA will report on all systems running on this Image using the SMF files defined for the Image.
- A Logger and Image combination plus a Group. This is useful to uniquely identify a system when there is more than one of the same name defined in System Definitions.
- A Group alone. CICS PA will report on all System and Image combinations in the Group to produce a single consolidated report.
CICS PA uses the System Selection in JCL generation to build the INput(SMFIN001,SMFIN002,SMFIN003,...) operand and corresponding //SMFINnnn DD statements.
- Output
- CICS PA provides a default Recap Report Output DDname in the format LOEXnnnn where nnnn is 0001-9999.
The line actions are the same as on similar Reports list panels. See Performance List report.
To display the System Logger Extract panel, enter line action S against the System Logger 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.
File Systems Options Help
------------------------------------------------------------------------------
SAMPLE - System Logger Extract
Command ===> _________________________________________________________________
System Selection: Report Output:
Logger . . CICSP001 + DDname . . . . . . . . . LOEX0001
Image . . MVS1____ +
Group . . ________ +
Output Data Set:
Data Set Name . . 'CICSP001.EXTRACT'____________________________
Disposition . . . 1 1. OLD 2. MOD (If cataloged)
Extract Format: Enter "/" to select option
Delimiter . . ; ⁄ Include Field Labels
_ Numeric Fields in Float format
Selection Criteria:
_ Logger
Logstream Name . . . __________________________
Structure Name . . . ________________
Use this panel to specify extract options and record selection criteria for the System Logger 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 format is fixed.
The options are:
- System Selection
- System Selection identifies the System Logger(s) and associated
SMF files you want to report against. Any combination of Logger, Image,
or Group can be specified but must be defined in System Definitions.
You can use Prompt (F4) to select from a list. To link directly
to System Definitions, select Systems in the action bar. Specify either:
- A Logger.
- A Logger for a particular Image. This identifies a particular System Logger when there is more than one with the same ID.
- An Image. CICS PA will report on all systems running on this Image using the SMF files defined for the Image.
- A Logger and Image combination plus a Group. This is useful to uniquely identify a system when there is more than one of the same name defined in System Definitions.
- A Group alone. CICS PA will report on all System and Image combinations in the Group to produce a single consolidated report.
CICS PA uses the System Selection in JCL generation to build the INput(SMFIN001,SMFIN002,SMFIN003,...) operand and corresponding //SMFINnnn DD statements.
- Data Set Name
- The name of the data set 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 assigns a default DDname CPAOLEnn where nn is a sequential number 01-99 to ensure uniqueness.
When specifying the data set name, 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.
- Numeric Fields in Float format
- Select (⁄) to write numeric fields in the extract in S390
FLOAT format. CICS PA JCL
generation translates this to the FLOAT 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.
- Selection Criteria
- To specify Selection Criteria to filter the System Logger records
on time period and other field values, enter S next
to Logger.
Line Actions: Valid line actions are:
- ⁄
- Display the menu of line actions.
- S
- Select to display the subpanel where Selection Criteria for this extract can be specified. See Specifying Selection Criteria for a discussion on how to do this.
- A
- Activate the Selection Criteria so they are generated for this extract when the Report Set is submitted. Selection Criteria can only be activated if one or more Select Statements are specified and not all are excluded. An asterisk (*) indicates they are active.
- D
- Deactivate the Selection Criteria. Any you have specified here will not be used.
CICS PA JCL generation translates Selection Criteria to the SELECT(LOGGER operand.
Optionally, specify the Logstream Name and Structure Name patterns to be reported. Masking characters % and * are allowed. Examples of possible patterns are:- TEST.DFHLOG
- which must match exactly
- PROD.*
- which can match PROD.DFHLOG
- PROD.MVSA%
- which can match PROD.MVSA1, but not PROD.MVSA1LOG
These options generate the LOGSTREAM('name.or.pattern') and STRUCTURE('name.or.pattern') operands.