When you have connected to the database, or loaded the csv 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 Connecting to a database to connect to a database, or Loading csv data in the CICS PA plug-in to load csv data , before continuing.
A database
can contain a very large amount of data. When you have connected to
a database you must first define the date and time range for the data
you want to analyze. You click the Dates tooltip icon in
the Overview view to display the "Restrict analysis time period" dialog
and select the date range to analyze as shown in the following screen
capture.
When you have selected the date range and clicked OK, a list of the Applids in the date range is displayed in the Overview view. When you select one or more Applids, the resulting data is shown in the Sheet view. You can use the filter fields to filter for specific Applids or Transaction IDs, by entering part or all of the required string. Note that wild cards are not supported in these filter fields. You can refine the data further by selecting one or more Transaction IDs in the Overview view. An example screen capture is shown below, showing 12 records for Applid IYCYZC22 and Transaction ID CWBG, in the selected date range.
You can use the Tree view to see the structure of the data in the database. The data is structured in date, time, Applid, and Transaction ID 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: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 by right-clicking the selection and clicking Sheet view. 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 database connection called PA Database, and that the selected data consists of 495 records. The information line below that tab shows the selection criteria, in this example, the Applids that are selected and the date range.
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 or selecting different Applids or Transaction IDs, you can reduce the data selection 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.