HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

Static DBEFile Screen 

This screen lists the file capacity of each DBEFile in a DBEFileSet.


            

To invoke the Static DBEFile screen, use the d command from the Static
subsystem or the /st d 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.

DBEFILESET       The percentage of file space in use in the DBEFileSet,
FULLNESS %       calculated as follows:

                      DBEFILESET FULLNESS %  = (FSUSED PAGES / FSMAX PAGES) * 100

FSUSED PAGES     The number of pages in use in the DBEFileSet.  This
                 value is equivalent to the value of the DBEFSUPAGES
                 column of SYSTEM.DBEFILESET plus the number of page
                 table pages in the DBEFileSet.  A used page might not be
                 full.

FSMAX PAGES      The maximum number of pages in the DBEFileSet.  This
                 value is equal to the DBEFSMPAGES column of
                 SYSTEM.DBEFILESET.

DBEFILE          The name of the DBEFile contained in the DBEFileSet.  If
                 the DBEFile has been detached with the SQLUtil
                 DETACHFILE command, the keyword DETACHED appears.

TYP              The type of the DBEFile, as listed below:

                 TBL      Table data pages, including hash structures and
                          long column data

                 IDX      Index or referential constraint pages

                 MIX      Mixed, indicating either table data, index, or
                          referential constraint pages

BD               Whether a DBEFile is bound, indicated by an asterisk.
                 When a table is defined as hashed, a group of primary
                 pages from up to 16 DBEFiles is allocated for it.  The
                 DBEFiles are bound, that is, they are unavailable for
                 any other table, index, or referential constraint.  You
                 can only insert data for the hashed table itself into
                 these DBEFiles.  The last bound DBEFile might have
                 unused space, which ALLBASE/SQL can use for overflow
                 pages for the hash structure.

DBEFILE          The percentage of file space in use in the DBEFile,
FULLNESS %       calculated as follows:

                      DBEFILE FULLNESS % = (USED PAGES / MAX PAGES) * 100

USED PAGES       The number of pages in use in the DBEFile.  This value
                 is equivalent to the DBEFUPAGES column of SYSTEM.DBEFILE
                 plus the number of page table pages in the DBEFile.

MAX PAGES        The maximum number of pages in the DBEFile.  This value
                 is equivalent to the DBEFMPAGES column of SYSTEM.DBEFILE
                 and is specified with the CREATE DBEFILE statement.

Display Conventions 

The full bright, inverse video bars represent the total amount of file
space.  The quantity of space occupied is indicated by the half bright,
inverse video bars, which are delimited on the right with exclamation
points.

Related SET Commands 

Use the SET DBEFILESET command to improve performance and display only
those tables contained in a particular DBEFileSet.

MPE/iX 5.0 Documentation