You can limit the number of records that are displayed
in the Sheet view by applying various selection
criteria in the CICS SMF Records view. You can
set the number of records to return for each request.
About this task
By default, the Sheet view updates
automatically when you change your selection in the CICS
SMF Records view. To change this option, use the Link
to Selection icon
in the toolbar of the Sheet view.
You
can use the
Selected records tab in the
CICS
SMF Records view to apply the following selection criteria
to the records:
- Select records that are associated with one or more APPLIDs (except
for Application context summary records).
- For Application context summary records, select records that are
associated with a platform, application name, application version,
or application operation.
- For Performance List or transaction summary records, select records
that are associated with one or more Transaction IDs.
- Select records from the last day, week, month, quarter, or year.
- Select records from a specified time period.
- Select one or more transaction IDs.
- Select a specific performance summary report.
You can use the Preferences window
to set the number of records to return for each request.
Procedure
Start from the Selected records tab
in the CICS SMF Records view.
- To display the records that are associated with an APPLID,
click the name of the APPLID. You can use the Shift or
Ctrl keys to select more than one APPLID. To filter the APPLID list,
type part or all of the APPLID name in the Applid field
and click the Apply filter icon
.
You can use wildcards in the name. To remove the filter, click the Clear
filter icon
.
- For Application context summary records, to display the
records that are associated with a platform, application name, application
version, or application operation, click the name of each required
attribute. You can use the fields and controls in a similar
way as described earlier for the APPLID.
- For Performance List or transaction summary records, to
display the records that are associated with a Transaction ID, click
the name of the Transaction ID. You can use the fields
and controls in a similar way as described earlier for the APPLID.
- To select records from the last day, week, month, quarter,
or year, click the arrow on the Performance Analyzer date
dialog icon
on the toolbar, then click
the required time period on the menu.
- To select records from a specific time period, use the
following steps:
- Click the Performance Analyzer date dialog icon
on the toolbar or on the tab to display
the Date-time selection window.
- Clear the Restrict to relative period check
box and use the controls on the window to specify the date and time
period you require.
- Click OK.
- To use the date/time tree to filter the records, expand
the tree to show the elements you require, and select those elements. You can use this method to look at the data from a single performance
summary report.
- To set the number of records to retrieve for each request,
see Setting database retrieval parameters. You can use this setting together with column sorting to return
the top or bottom subset of data. For details, see Customizing the layout in the Sheet view.
What to do next
You can use the Sheet view to filter
the data further. For details, see Writing a freeform filter.
You
apply a predefined layout to the Sheet view to
aid analysis. See Applying a layout in the Sheet view.
You
can also sort the records by column or create your own layout. See Customizing the layout in the Sheet view.
You can create
a CSV file from data in the Sheet view. See Working with CSV data.