Sheet view
The Sheet view displays the selected monitoring or statistics data as a spreadsheet. You can view performance summary records, performance list records, and statistics records from the CICS® PA host database, or CSV data that is loaded into the CICS PA plug-in.
The view title shows the type of monitoring or statistics record, the number of records retrieved, and the total number of records, or the name of the CSV file.
The information line shows the current selection criteria, for example, the APPLID and time period, and the current layout.
- Summary data records display an aggregation of performance data that is averaged over a time period, for example the Transaction summary.
- Performance List records display a single time slice of transaction performance data and any associated transaction performance alerts.
- Statistics records display statistical data, for example Transaction Manager records.
- You can reduce the data displayed and sort it so that you can
identify significant situations:
- You can apply a layout.
- You can apply a filter.
- You can customize the layout.
- You can sort the data by column.
- You can select one or more records for more detailed analysis.

Toolbar
- Link to Selection icon
. Update the Sheet view automatically when you change a selection in the CICS SMF Records view. See Refining the data selection.
- Clear sort icon
. Clear the current sorting by column and return to a chronological list. See Customizing the layout in the Sheet view.
- Data filters tool. Filter the data in the Sheet view. See Writing a freeform filter.
- Apply filter icon
. Run the filter in the Data filters field.
- Reset filter icon
. Clear the filter in the Data filters field.
- View Menu icon
. Access the following options:
- Clear sort. Clear the current sorting by column and return to a chronological list. See Customizing the layout in the Sheet view.
- Reset Columns. Reset the columns to their default settings. See Customizing the layout in the Sheet view.
- Equalize Column Widths. Set the columns to equal widths. See Customizing the layout in the Sheet view.
- Customize Colums. Select which columns to display in the view. See Customizing the layout in the Sheet view.
- Save Layout As. Save a customized layout and optionally save the filter. See Saving a layout or a filter in the Sheet view.
- Apply Layout. Apply a predefined or saved user-defined layout to the view. See Applying a layout in the Sheet view.
- Import Layouts. Import layouts that are saved to a definition file. See Importing or exporting layouts in the Sheet view.
- Export Layouts. Export saved user-defined layouts See Importing or exporting layouts in the Sheet view.
Information line
You can use the Current layout hyperlink in the information line to apply a layout. See Applying a layout in the Sheet view.
Column headers
You can use the column headers to change the size of a column, reposition a column, and sort the data by column. See Customizing the layout in the Sheet view.
Context menu
- Right-click a summary data record, then click Performance summary to view a detailed analysis of the specific record.
- Use the Shift or Ctrl keys to select more than one summary data
record, click Transaction performance, then
click the required analysis type on the menu:
- CICS Response time
- User CPU time
- Threadsafe
- Storage usage
- File Request activity
- Right-click a Performance List record, click Open to view transaction performance conditions in a graphical format in the Performance detail view.
- Right-click a statistics record, then click Open to view a graphical view that provides detailed analysis of the record.
- Right-click a statistics record, click a Link menu
option, then click the required resource type on the menu to view
records that share certain parameters and attributes. The following
example shows the Link menu options for a Transactions
record.