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.

Figure 1. System Logger Extracts
   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.

Figure 2. System Logger Extract
   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.