SampleIO Objects Screen [ ALLBASE/SQL Performance and Monitoring Guidelines ] MPE/iX 5.0 Documentation
ALLBASE/SQL Performance and Monitoring Guidelines
SampleIO Objects Screen
This screen lists the database objects currently residing in the data
buffer pool.
Click here to view figure.
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
HP 3000 Manuals