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:
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:
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.
CICS PA JCL generation translates this to DELIMIT('delimiter'). Note that the value is enclosed in quotes in this operand.
Blank out the field if you do not want field labels written. CICS PA JCL generation translates this to the NOLABELS operand.