 |
» |
|
|
|
SYSTEM.DBEFILESET contains information about
DBEFileSets. This table initially contains a row for
each DBEFileSet created when the DBEnvironment is configured.
A row is added, updated, or deleted whenever
ALLBASE/SQL processes an ADD DBEFILE, CREATE DBEFILESET,
REMOVE DBEFILE, or DROP
DBEFILESET statement. SYSTEM.DBEFILESET and SYSTEM.DBEFILE contain
all the information about where tables
and indexes are stored. Table 8-13 System.DBEFileSet | Column Name | Type | Length | Description |
|---|
| DBEFSNAME | CHAR | 20 | Name of the DBEFileSet | | DBEFSNDBEFILES | INTEGER | 4 | Number of DBEFiles in the DBEFileSet | | DBEFSNPAGES | INTEGER | 4 | Number of pages in the DBEFileSet
(the sum of the pages in all
associated DBEFiles) | | DBEFSUPAGES | INTEGER | 4 | Number of pages in the DBEFileSet containing table
and index data, excluding page table pages (the sum
of the used pages in all associated DBEFiles) | | DBEFSPTPAGES | INTEGER | 4 | Number of page table pages in the DBEFileSet | | DBEFSMPAGES | INTEGER | 4 | Total maximum number of pages the
DBEFileSet may be expanded (the sum of all DBEFMPAGES in System.DBEFile
for the associated DBEFile) | | CTIME | CHAR | 16 | Time of creation: yyyymmddhhmmsstt | | ATTACHED | CHAR | 2 | Attached: Y for yes, N for no |
EXAMPLE | |
SELECT * FROM System.DBEFileSet ;
--------------------+--------------+-----------+-----------
DBEFSNAME |DBEFSNDBEFILES|DBEFSNPAGES|DBEFSUPAGES
--------------------+--------------+-----------+-----------
SYSTEM | 2| 100| 8
PURCHFS | 2| 100| 6
WAREHFS | 2| 100| 4
ORDERFS | 2| 100| 5
---------------------------------------------------------------------------
Number of rows selected is 4
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> r
+------------+-----------+----------------+--------
|DBEFSPTPAGES|DBEFSMPAGES|CTIME |ATTACHED
+------------+-----------+----------------+--------
| 4| 100|1990090614175200|Y
| 2| 100|1990090614192370|Y
| 2| 100|1990090614194160|Y
| 2| 100|1990090614200170|Y
---------------------------------------------------------------------------
Number of rows selected is 4
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|
|
