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.
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.