SampleIO Indexes Screen [ ALLBASE/SQL Performance and Monitoring Guidelines ] MPE/iX 5.0 Documentation
ALLBASE/SQL Performance and Monitoring Guidelines
SampleIO Indexes Screen
This screen provides index and referential constraint I/O information.
Click here to view figure.
To invoke the SampleIO Indexes screen, use the i command from the
SampleIO subsystem or the /sa i command from other subsystems. For more
information about using the SAMPLEIO subsystem, see the chapter
"Troubleshooting with SQLMON."
Field Definitions
REFRESH The screen refresh rate, in seconds.
DBEFILESET The name of the DBEFileSet. The indexes and referential
constraints contained within a DBEFileSet are listed
below the DBEFileSet name.
SORTSAMPLEIO An indicator of how the indexes and referential
constraints are sorted. The indexes and referential
constraints are sorted in descending order by the value
in the column indicated by the asterisk. In the above
example, the indexes and referential constraints are
sorted by TOTALIO values. For more information, see the
description of the SET SORTSAMPLEIO command.
OWNER.TABLE The name of the table upon which the index or
referential constraint is defined.
INDEX, The name of the index or referential constraint.
CONSTRAINT
SWAPIN An approximation of read I/O for the index or
referential constraint.
SWAPOUT An approximation of write I/O for the index or
referential constraint.
TOTALIO The sum of the SWAPIN and SWAPOUT values. This value
approximates total I/O.
Display Conventions
When the DISPLAYSAMPLES variable is set to ON, a row displayed in inverse
video indicates that index I/O has occurred during the most recent
refresh interval.
Related SET Commands
The SET commands in the following table affect this screen.
-----------------------------------------------------------------------------------------------
| | | |
| Command | Description | Example |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| SET DBEFILESET | Limits the objects displayed | SET DBEFILESET PurchFS |
| | to those in the DBEFileSet | |
| | specified. | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| SET DISPLAYSAMPLES | Determines whether a SampleIO | SET DISPLAYSAMPLES ON |
| | screen is displayed when | |
| | samples are collected. | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| SET REFRESH | Controls the refresh rate of | SET REFRESH 5 |
| | the screen. | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| SET SAMPLING | Enables sampling of the data | SET SAMPLING ON |
| | buffer pool. | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| SET SORTSAMPLEIO | Sorts objects in descending | SET SORTSAMPLEIO 3 |
| | order according to the value | |
| | of the specified column. | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| SET TOP | Limits the number of objects | SET TOP 2 |
| | displayed. | |
| | | |
-----------------------------------------------------------------------------------------------
MPE/iX 5.0 Documentation
HP 3000 Manuals