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.

You can view the following types of records from the CICS PA host database:
  • 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 use the Sheet view for the following purposes:
  • 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.
    The data displayed also depends on the selection criteria you set in the CICS SMF Records view. See Refining the data selection.
  • You can select one or more records for more detailed analysis.
Sheet view showing transaction summary records

Toolbar

You can use the following icons and tools in the toolbar of the 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

Use the context menu to analyze one or more records in greater detail. The menu options and their availability depend on the type of record displayed:
  • 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.
    Link menu

Status bar

If the total number of records is greater than the number of records set to retrieve for each request, you can use Retrieve more to retrieve the next set of records. See Customizing the layout in the Sheet view. To control the number of records retrieved, see Setting database retrieval parameters.