Displaying CSV data

When you use the CICS® PA plug-in, you can analyze CMF performance data that has been extracted and formatted as a CSV file using CICS Performance Analyzer for z/OS®. You must not edit or change the CSV data in any way otherwise errors are likely to occur. You can view data that you have extracted in the past, however, if you want to see new data from version 3.2 you must extract it from the PA host database.

About this task

The first time you click a CSV file in the Project Explorer view, the CICS PA plug-in performs an analysis of the data. The analysis might take a few seconds to complete. When the analysis is complete, a plus icon (an arrow on Linux) displays next to the file. Clicking the icon, and subsequent icons, expands the file and displays the file contents in the following cascading order: In the following screen capture, the file sample.CSV in the folder Old CSV files contains data summarized by start date and time, and using various time intervals. The start time 03:30:00 contains an APPLID, APOC3C1, containing two transaction IDs.
A picture of the Project Explorer view showing a folder expanded to show a CSV file and all expanded branches.

You can select a sub-set of data and copy it from CICS PA and paste it into a spreadsheet application:

Procedure

  1. Right-click the records that you want to use and select Sheet view from the context menu. A new tab opens displaying the records you have chosen.
  2. Copy the records.
  3. Open your spreadsheet application and paste the records into it. The data is displayed in the spreadsheet application.

Example

In the Project Explorer view you can select a single Transaction ID, multiple Transaction IDs, a single time period, multiple time periods, a single date period, multiple date periods, or any combination. As you make your selection, the spreadsheet view is updated. See The Sheet view topic for more information.