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:

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:

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.

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.

Information Information

Feedback


Timestamp icon Last updated: Thursday, 7 November 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//users-guide/syslogx.htm