Displaying CSV data

You can use the CICS® PA plug-in to display and analyze CSV data.

Before you begin

You must have a suitable CSV file loaded. See Obtaining CSV data and Loading CSV data.

Do not edit or change the CSV data in any way, because this can cause errors.

Procedure

  1. For a new CSV file, in the Project Explorer view, click the file. The CICS PA plug-in analyzes the data, which might take a short time to complete. When analysis completes, an icon to expand the file is displayed. You can expand the file to show the following file contents:
    • Start date
    • Start time
    • APPLID
    • Transaction ID
  2. For an existing CSV file, expand the file to show the records you require.

    The following example screen shows the sample.csv file, expanded to show a start time with two APPLIDs and the transaction ID for the first APPLID.

    Project Explorer view showing a CSV file and all expanded branches.

  3. To display a transaction summary in the sheet view, select the records you require, right-click, then click Transaction summary. You can select records by start date, start time, APPLID, or Transaction ID. You can use the Shift or Ctrl keys to select multiple records. The selected records are displayed in a new tab in the sheet view. If you change your selection, the sheet view is updated.
  4. To display a transaction performance visualization, right-click the required APPLID, click Transaction performance, then click the required visualization from the menu.
  5. To display the performance history for a transaction, right-click the required Transaction ID then click Performance summary.
  6. If you are connected to a CICS system, to display a view of the related resources, right-click the required APPLID or Transaction ID, click Show View, then click the required resource type from the menu.

What to do next

You can copy records in the sheet view and paste them into a spreadsheet application. See Sheet view.