 |
» |
|
|
|
This screen lists the database objects currently residing in
the data buffer pool.
![[sampleob]](img/sampleob.gif)
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 [/INDEX, CONSTRAINT]
The name of the database object residing in the data buffer pool.
A database object can be a table, index, 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 those contained in the DBEFileSet
specified. | SET DBEFILESET PurchFS | | SET DISPLAYSAMPLES | Determines whether a SampleIO screen is displayed when samples are collected. | SET DISPLAYSAMPLES ON | | SET REFRESH | Controls the refresh rate of the screen. | SET REFRESH 5 | | SET SAMPLING | Enables sampling of the data buffer pool. | SET SAMPLING ON |
|
