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 screen is displayed
when samples are collected.
| SET DISPLAYSAMPLES ON |
| SET REFRESH | Controls the refresh rate of the screen. | SET REFRESH 5 |
| SET SAMPLING | Enables sampling of the data buffer pool. | SET SAMPLING ON |
| SET SORTSAMPLEIO | Sorts DBEFiles in descending order according to the value
of the specified column. | SET SORTSAMPLEIO 3 |
| SET TOP | Limits the number of DBEFiles displayed. | SET TOP 10
|
![[sampio]](img/sampio.gif)
