HP 3000 Manuals

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.


            

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