This screen displays information about the indirect rows in each table of a DBEFileSet.
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.
![[indirect]](img/indirect.gif)
