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.
- On the Historical Database menu, select option 6 Extract.
The list of HDBs appears.
- 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)
- 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.
- 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.
- Transfer the CSV file to your PC as an ASCII text file with file extension .csv.