SampleIO TabIndex Screen [ ALLBASE/SQL Performance and Monitoring Guidelines ] MPE/iX 5.0 Documentation
ALLBASE/SQL Performance and Monitoring Guidelines
SampleIO TabIndex Screen
This screen displays I/O information about a specific table, its indexes,
and its referential constraints.
Click here to view figure.
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, The index or referential constraint name.
CONSTRAINT
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 | SET DISPLAYSAMPLES ON |
| | screen is displayed when samples | |
| | are collected. | |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| SET REFRESH | Controls the refresh rate of the | SET REFRESH 5 |
| | screen. | |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| SET SAMPLING | Enables sampling of the data | SET SAMPLING ON |
| | buffer pool. | |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| SET SORTSAMPLEIO | Sorts objects in descending order | SET SORTSAMPLEIO 2 |
| | according to the value of the | |
| | specified column. | |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| SET TOP | Limits the number of objects | SET TOP 4 |
| | displayed. | |
| | | |
----------------------------------------------------------------------------------------------
MPE/iX 5.0 Documentation
HP 3000 Manuals