HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

SampleIO Tables Screen 

This screen provides table I/O information.


            

To invoke the SampleIO Tables screen, use the tabl command from the
SampleIO subsystem or the /sa tabl 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 tables contained within
                 the DBEFileSet are listed below the DBEFileSet name.

SORTSAMPLEIO     An indicator of how the tables are sorted.  The tables
                 are sorted in descending order by the value in the
                 column indicated by the asterisk.  In the example above,
                 the tables are sorted by the TOTALIO values.  For more
                 information, see the description of the SET SORTSAMPLEIO
                 command.

OWNER.TABLE      The table name.  Long column data is stored in internal
                 ALLBASE/SQL tables which have no entries in
                 SYSTEM.TABLE. To construct a name for these tables,
                 SQLMON appends the column number of the long column to
                 the table name.  For example, the PURCHDB.REPORTS(3)
                 entry represents the table that holds the long column
                 data of the third column of the PURCHDB.REPORTS table.

SWAPIN           An approximation of read I/O for the table since the SET
                 DBENVIRONMENT command was issued.

SWAPOUT          An approximation of write I/O for the table since the
                 SET DBENVIRONMENT command was issued.

TOTALIO          The sum of the SWAPIN and SWAPOUT values.  This value
                 approximates the total I/O.

Display Conventions 

When the DISPLAYSAMPLES variable is set to ON, a value displayed in
inverse video indicates that table 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 tables displayed to     | SET DBEFILESET PurchFS    |
|                           | those contained 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 the   | SET REFRESH 5             |
|                           | screen.                            |                           |
|                           |                                    |                           |
----------------------------------------------------------------------------------------------
|                           |                                    |                           |
| SET SAMPLING              | Enables sampling of the data       | SET SAMPLING ON           |
|                           | buffer pool.                       |                           |
|                           |                                    |                           |
----------------------------------------------------------------------------------------------
|                           |                                    |                           |
| SET SORTSAMPLEIO          | Sorts tables in descending order   | SET SORTSAMPLEIO 3        |
|                           | according to the value of the      |                           |
|                           | specified column.                  |                           |
|                           |                                    |                           |
----------------------------------------------------------------------------------------------
|                           |                                    |                           |
| SET TOP                   | Limits the number of tables        | SET TOP 10                |
|                           | displayed.                         |                           |
|                           |                                    |                           |
----------------------------------------------------------------------------------------------

MPE/iX 5.0 Documentation