This screen displays information about the indirect rows
in each table of a DBEFileSet.
![[indirect]](img/indirect.gif)
To invoke the Static Indirect screen, use the i command
from the Static subsystem or the /s i command from
other subsystems.
Field Definitions |
 |
- DBEFILESET
The name of the DBEFileSet.
The keyword DETACHED means that the DBEFileSet is detached.
The keywords DETACHED DBEFILES mean that the DBEFileSet is
attached, but some of the DBEFiles within it are detached.
- OWNER.TABLE
The name of each table in the DBEFileSet.
Long column data is stored in internal ALLBASE/SQL tables that
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.
- TABLE INDIRECT ROW %
The percentage of indirect rows
within the table. To access an indirect row,
ALLBASE/SQL must perform two page fetches.
The first fetch obtains the row's address, and the
second fetch acquires the row itself. Indirect rows degrade performance
by increasing the amount of I/O.
- TOTAL ROWS
The total number of rows in the table.
This value is equivalent to the NROWS column of SYSTEM.TABLE.
Related SET Commands |
|
Use the SET DBEFILESET command to improve performance
and to display only those tables
contained in a particular DBEFileSet.
