 |
» |
|
|
|
This screen provides information about the size of
tables, indexes, and referential constraints in a DBEFileSet.
![[size]](img/size.gif)
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 PAGES
The number of page table pages in the DBEFileSet.
A 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 FULLNESS %
The percentage of file space in use
in the DBEFileSet, 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. |
