This screen provides index and referential constraint
I/O information.
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, CONSTRAINT
The name of the index or referential 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 to those in the DBEFileSet
specified.
| SET DBEFILESET PurchFS |
| 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 objects
in descending order according to the value
of the specified column. | SET SORTSAMPLEIO 3 |
| SET TOP | Limits the number of objects displayed. | SET TOP 2
|
![[indexes]](img/indexes.gif)
