SampleIO Screen [ ALLBASE/SQL Performance and Monitoring Guidelines ] MPE/iX 5.0 Documentation
ALLBASE/SQL Performance and Monitoring Guidelines
SampleIO Screen
This screen displays DBEFile I/O information.
Click here to view figure.
To invoke the SampleIO screen, use the s command from the SampleIO
subsystem or the /sa 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.
SORTSAMPLEIO An indicator of how the DBEFiles are sorted. The
DBEFiles are sorted in descending order by the value in
the column indicated by the asterisk. In the example
above, the DBEFiles are sorted by the TOTALIO values.
For more information, see the description of the SET
SORTSAMPLEIO command.
DBEFILESET The name of the DBEFileSet to which the DBEFile has been
added.
DBEFILE The name of the DBEFile belonging to the DBEFileSet.
SWAPIN An approximation of read I/O for the DBEFile.
SWAPOUT An approximation of write I/O for the DBEFile.
TOTALIO The sum of the SWAPIN and SWAPOUT values. This value
approximates the total I/O.
Display Conventions
When the DISPLAYSAMPLES variable is set to ON, a row displayed in inverse
video indicates that DBEFile 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 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 DBEFiles in descending | SET SORTSAMPLEIO 3 |
| | order according to the value | |
| | of the specified column. | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| SET TOP | Limits the number of DBEFiles | SET TOP 10 |
| | displayed. | |
| | | |
-----------------------------------------------------------------------------------------------
MPE/iX 5.0 Documentation
HP 3000 Manuals