Extract performance data to CSV

This task describes how to create CSVs using HDBs. However, CSVs can also be created by using the Performance Extract report within Report Sets.

  1. On the Historical Database menu, select option 6 Extract.

    The list of HDBs appears.

  2. Select the HDB that you want to export.
    The Run SUMMARY HDB Extract pop-up window appears:
                          Run SUMMARY HDB Extract - EXPLORE4 
    Command ===> ___________________________________________________________
    
    Specify Extract request options then press Enter to continue submit. 
    
    ───── Report Interval ──────   HDB contains data 
         YYYY/MM/DD HH:MM:SS.TH    in the range: 
    From __________ ___________    2009/02/01 19:00   Extract Recap: 
    To   __________ ____________   2009/02/03 23:00    DDname . . . HXTS0001 
    
    Output Data Set: 
     Data Set Name . . 'USER.CICSPA.EXTRACT.CSV'                        
     Disposition . . . 1  1. OLD  2. MOD   (If cataloged) 
    
    Extract Format:                         Enter "/" to select option 
     Form . . . . . .  EXPLORE4  +          / Include Field Labels 
     Delimiter . . . . ,                    _ Numeric Fields in Float format 
    
    Processing Options:                     Enter "/" to select option 
     Time Interval . . ________ (hh:mm:ss)  / Edit JCL before submit 
     Precision . . . . 4        (4-6)
  3. Fill in the fields on the panel.

    In the Form field, press Prompt (F4) to select a compatible report form. Example: select EXPLORE5 if you are using the CICS PA plug-in on CICS® TS V5.1.

    If the required EXPLOREn form is not defined, select Samples in the action bar of the Report Forms panel to add the samples to your Report Forms data set.

    Press Enter to submit the extract job.

  4. Tips for extracting CSV files
    • A quick way to extract all data in the HDB is to leave the "from" and "to" dates and times blank.
    • To use the CSV file on a PC with the CICS PA plug-in:
      • Specify a comma (,) as the delimiter character, not the CICS PA default semicolon (;).
      • Include field labels.
      • Do not select the (z/OS® host-specific) float format for numeric fields.
  5. Transfer the CSV file to your PC as an ASCII text file with file extension .csv.

Information Information

Feedback


Timestamp icon Last updated: Saturday, 8 February 2014


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