HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

Static Indirect Screen 

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   The percentage of indirect rows within the table.  To
ROW %            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.

MPE/iX 5.0 Documentation