 |
» |
|
|
|
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 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.
|
![[size]](img/size.gif)
