HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

SampleIO Indexes Screen 

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,           The name of the index or referential constraint.
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   | SET DBEFILESET PurchFS         |
|                           | to those in the DBEFileSet     |                                |
|                           | specified.                     |                                |
|                           |                                |                                |
-----------------------------------------------------------------------------------------------
|                           |                                |                                |
| 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 objects in descending    | SET SORTSAMPLEIO 3             |
|                           | order according to the value   |                                |
|                           | of the specified column.       |                                |
|                           |                                |                                |
-----------------------------------------------------------------------------------------------
|                           |                                |                                |
| SET TOP                   | Limits the number of objects   | SET TOP 2                      |
|                           | displayed.                     |                                |
|                           |                                |                                |
-----------------------------------------------------------------------------------------------

MPE/iX 5.0 Documentation