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. When transferred to a workstation file the extracted System Logger 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.
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:
CICS PA uses the System Selection in JCL generation to build the INput(SMFIN001,SMFIN002,SMFIN003,...) operand and corresponding //SMFINnnn DD statements.
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:
CICS PA uses the System Selection in JCL generation to build the INput(SMFIN001,SMFIN002,SMFIN003,...) operand and corresponding //SMFINnnn DD statements.
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.
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.
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.
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.
Line Actions: Valid line actions are:
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:These options generate the LOGSTREAM('name.or.pattern') and STRUCTURE('name.or.pattern') operands.