When you have loaded the data into CICS PA Explorer, you
can select and view all, or a subset of, the data in the CICS PA sheet
view.
If the data is not yet loaded, follow the steps in the task Loading data in CICS PA Explorer to load csv data, or Connecting to a database to connect to a database,
before continuing.
The first time you click a file in the Project Explorer view, CICS
PA Explorer 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:
- Start date
- Start time
- APPLID
- Transaction ID
In the following example, the csv file XPLR_C.csv in Folder 1 contains
data summarized by start date and time, and using five minute time
intervals. The start time 13:40:00.000 contains one APPLID, PDQSICU,
containing two transaction IDs.

Viewing a single item of data
To select
a single item of data, perform the following steps:
- Expand the file in the PA Explorer view by clicking the plus icon
(an arrow on Linux) alongside the file. Repeat the action until the
data you want to view is displayed.
- Right-click the data you want to view.
- Click Sheet view in the menu.
The data is displayed in the sheet view in CICS PA Explorer.
The details displayed depend on the selection you make:
- If you select a single transaction ID, the sheet view displays
details only for the transaction IDs.
- If you select a single application, the sheet view displays details
for all the transaction IDs in the APPLID.
- If you select a single start time, the sheet view displays details
for all the transaction IDs and the APPLIDs for the start time.
- If you select a single start date, the sheet view displays details
for all the start times, APPLIDs, and transaction IDs for that start
date.
Viewing multiple rows of data
You can select
and view data in any combination of start dates, start times, APPLIDs,
or Transaction IDs. To select multiple rows of data, perform the following
steps:
- Expand the file in the PA Explorer view by clicking the plus icon
(an arrow on Linux) alongside the file. Repeat the action until the
data you want to view is displayed.
- Highlight the first item of data you want to view by left-clicking.
- Select subsequent items of data using the shift or Ctrl keys.
- When the selection is complete, press the shift or Ctrl key and
right-click one of the selections, and click Sheet view in
the menu.
Your selection displays in the CICS PA sheet view. You
can further refine your data by selecting a subset of the data in
the sheet view, right-clicking your selection, and clicking Sheet
view in the menu. You selection opens in a new sheet view.
Sorting the data
You can sort the data in
the sheet view in ascending or descending order by clicking a column
header.
When you click a column header, an up or
a down arrow is displayed alongside the column
name. The up arrow indicates that the data in the column is sorted
in ascending order. The down arrow indicates that the data is sorted
in descending order.