When you have loaded the data into the CICS® PA plug-in, you can select and view all, or a subset of, the data, as a spreadsheet in the CICS PA Sheet view.
If the data is not yet loaded into the CICS PA plug-in, follow the steps in the task Loading csv data in the CICS PA plug-in to load csv data, or Connecting to a database to connect to a database, before continuing.
In the following screen capture, the file sample.csv in the folder TESTF contains data summarized by start date and time, and using various time intervals. The start time 03:55:00.000 contains an APPLID, APOC3C1, containing two transaction IDs.
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. When you have made a selection you can display the data as a spreadsheet in the Sheet view before analyzing it further. The Sheet view is described later in this topic.
You can display some, or all of the data as a spreadsheet in the Sheet view. The data in each column can be sorted by clicking the column name, and the columns can be repositioned in the spreadsheet as required. From the Sheet view you can select one or more transactions for more detailed analysis, and view the new selection in a new Sheet view or in one or more of the graphical views.
The Sheet view is shown In the following screen capture. The view tab shows that the source for the data is the sample.csv file and that it has 44 records. The information line below that tab shows the path to the data, and the tree node selected to display the data.
The Sheet view shows all the data fields in the selected data source, however because of the amount of data, it is not always easy to identify out-of-line situations. By making use of the sort facility you can select a subset of the data for further analysis.
When you have
selected a subset, right click the selection, click Performance history,
and select one of the report options to analyze the data further.
For more information on analyzing data, see the related link.