This screen displays I/O information
about a specific table, its indexes, and its referential constraints.
To invoke the SampleIO TabIndex screen, use the tabi command
from the SampleIO subsystem or the /sa tabi command from
other subsystems.
You must specify a table name when invoking the SampleIO TabIndex
screen, either on the command line or at an SQLMON prompt:
SQLMONITOR {{OVERVIEW}} => /sa tabi PurchDB.Vendors
SQLMONITOR {{OVERVIEW}} => /sa tabi
OWNER.TABLE: PurchDB.Vendors
|
Field Definitions |
 |
- REFRESH
The screen refresh rate, in seconds.
- 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 SET SORTSAMPLEIO command.
- OWNER.TABLE
The name of the table.
- INDEX, CONSTRAINT
The index or referential constraint name.
- SWAPIN
An approximation of read I/O for the object
since the SET DBENVIRONMENT command was issued.
- SWAPOUT
An approximation of write I/O for the object
since the SET DBENVIRONMENT command was issued.
- 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 value displayed in inverse video indicates that
I/O on the database object 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 objects
in descending order according to the value
of the specified column. | SET SORTSAMPLEIO 2 |
| SET TOP | Limits the number of objects displayed. | SET TOP 4
|
![[tabindex]](img/tabindex.gif)
