HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

SampleIO Objects Screen 

This screen lists the database objects currently residing in the data
buffer pool.


            

To invoke the SampleIO Objects screen, use the o command from the
SampleIO subsystem or the /sa o command from other subsystems.  For
more information about 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 database objects within
                 the DBEFileSet are listed below the DBEFileSet name.

OWNER.TABLE      The name of the database object residing in the data
[/INDEX,         buffer pool.  A database object can be a table, index,
CONSTRAINT]      referential constraint, or page table page.  Because
                 temporary tables and page table pages do not have names, 
                 their tuple identifiers are listed instead. 
                 Long column data is stored in internal ALLBASE/SQL
                 tables which have no entries in SYSTEM.TABLE. To
                 construct a name for long column tables, SQLMON appends
                 the column number to the table name.

CURRENT PGS      The number of pages in the data buffer pool that the
                 database object currently occupies.

TOTALIO          An approximation of total I/O for the object since the
                 SET DBENVIRONMENT command was issued.  The characters
                 ???  appear when no I/O data is available for the
                 object.

Related SET Commands 

The SET commands in the following table affect this screen:

----------------------------------------------------------------------------------------------
|                           |                                    |                           |
|          Command          |            Description             |          Example          |
|                           |                                    |                           |
----------------------------------------------------------------------------------------------
|                           |                                    |                           |
| SET DBEFILESET            | Limits the objects 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.                       |                           |
|                           |                                    |                           |
----------------------------------------------------------------------------------------------

MPE/iX 5.0 Documentation