To customize the layout in the Sheet view,
you can set the number of records to retrieve, change the column layout,
sort the data by column, and filter the data.
About this task
Records in the Sheet view, especially
summary records and performance list records, can contain many columns
of data. For summary records and performance list records, a number
of predefined layouts are provided to display the appropriate data
for a specific analysis. If you require a different layout, you can
customize the layout to display only the data that you require for
analysis, then save the layout for future use.
For information
about predefined layouts, see Applying a layout in the Sheet view.
The
data displayed in the Sheet view is filtered
by the selection criteria used in the CICS SMF Records view.
For more information, see Refining the data selection. You can
filter the data further in the Sheet view and
save that filter with a layout.
Procedure
- To set the number of records to retrieve for each request,
see Setting database retrieval parameters.
If the total number of records is greater than this, to retrieve the
next set of records, click Retrieve more.
- To change the column layout, use the following options:
- To change the size of a column, click and drag the edge of the
column header to the required size.
- To reposition a column, click and drag the column header to the
required position.
- To set the columns to equal widths, click the View Menu icon
in
the toolbar of the view, then click Equalize Column Widths.
- To select which columns to display in the view, click the View
Menu icon
in the toolbar of the view, then click Customize
Colums. In the Customize Columns dialog, select column
names and use Add and Remove until
only the columns you want to view are listed in the Current viewer
columns pane. Use the Move column up
and Move
column down
icons to change the column order. When
your changes are complete, click Close.
- To reset the columns to their default settings, click the View
Menu icon
in the toolbar of the view, then click Reset
Columns.
- To sort the sort the data by any column in the view, use
the following options:
- For alphanumeric data, to sort the data in ascending order for
a column, click the column header. To sort the data in descending
order, click the column header again.
- For numeric data, to sort the data in descending order for a column,
click the column header. To sort the data in ascending order, click
the column header again.
- To return to a chronological list, click the column header again,
or click the Clear sort icon
in
the toolbar of the view.
Each new sort request uses the full set of data on the CICS® PA host
database, so sorting is fast, accurate, and flexible. For example,
to determine the transactions that had the highest CPU time average,
click the Total CPU time avg column header
once to sort the data in descending order.
You can use column
sorting in conjunction with setting the database retrieval parameters
to return the top or bottom subset of data (for example, the top 10
records). The data is accurate because the data is sorted on the CICS PA host
before retrieving the records.
- To filter the data, use the Data filters tool
in the toolbar of the view to filter data. For details, see Writing a freeform filter.
What to do next
After you create your customized layout, you can save it.
See
Saving a layout or a filter in the Sheet view.