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 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 |
| SET SORTSAMPLEIO | Sorts tables in descending order according to the value
of the specified column. | SET SORTSAMPLEIO 3 |
| SET TOP | Limits the number of tables displayed. | SET TOP 10
|
![[tables]](img/tables.gif)
