Static Size Screen [ ALLBASE/SQL Performance and Monitoring Guidelines ] MPE/iX 5.0 Documentation
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.
Click here to view figure.
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
HP 3000 Manuals