HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

Static Size Screen 

This screen provides information about the size of tables, indexes, and
referential constraints in a DBEFileSet.


            

To invoke the Static Size screen, use the s command from the Static
subsystem or the /st s 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 one or more of the DBEFiles
                 within it are detached.

TEMPORARY PAGES   

                 A label that appears just after the DBEFileSet name and
                 indicates that the DBEFileSet has temporary pages.
                 Temporary pages are usually allocated from the SYSTEM
                 DBEFileSet, and are used primarily for sorting table
                 data.

PAGE TABLE       The number of page table pages in the DBEFileSet.  A
PAGES            page table page is an internal ALLBASE/SQL directory
                 that holds information on up to 252 pages in a DBEFile.
                 Every DBEFile contains at least one page table page.

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

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

                 FSMAX PAGES is the maximum number of pages in the
                 DBEFileSet.

FSUSED PAGES     The number of pages in use in the DBEFileSet.  This
                 value includes all pages used for table data, indexes,
                 referential constraints, page table pages, and temporary
                 pages.

OWNER.TABLE      The names of the tables contained within the DBEFileSet.
                 Indexes and referential constraints are listed below the
                 table name, and are preceded by the following labels:

                 (INDEX)          A nonclustering index, created with the
                                  CREATE INDEX statement or by specifying
                                  a unique constraint.

                 (INDEX*)         A clustering index, created with the
                                  CREATE CLUSTERING INDEX statement or by
                                  specifying a unique constraint with the
                                  CLUSTERING ON CONSTRAINT clause in the
                                  CREATE TABLE statement.

                 (CONST)          A nonclustering PCR (parent-child
                                  relationship), created by defining a
                                  referential constraint.

                 (CONST*)         A clustering PCR (parent-child
                                  relationship), created by defining a
                                  referential constraint with the
                                  CLUSTERING ON CONSTRAINT clause in the
                                  CREATE TABLE statement.

                 ALLBASE/SQL stores long column data in internal 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.

TABLE PAGES      The number of pages allocated for the table.

INDEX PAGES      The number of pages allocated for the index or
                 referential constraint.

TOTAL PAGES      The total number of pages allocated for the table and
                 all indexes and referential constraints defined upon it.

Display Conventions 

The full bright, inverse video bars represent the total amount of file
space in the DBEFileSet.  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 to display only
those tables contained in a particular DBEFileSet.
[REV END]

MPE/iX 5.0 Documentation