HP 3000 Manuals HP 3000 Manuals
SampleIO Screen This screen displays DBEFile I/O information.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. | | | | | | -----------------------------------------------------------------------------------------------
![[]](../../pic3k/M012926/FFN663c50.gif)