 |
» |
|
|
|
SYSTEM.DBEFILE contains information about the
DBEFiles in the DBEnvironment.
Initially it contains
the DBEFiles created when the DBEnvironment is configured.
A row is added, updated, or deleted whenever
ALLBASE/SQL processes an ADD DBEFILE, ALTER DBEFILE, CREATE
DBEFILE, DROP DBEFILE, or REMOVE DBEFILE statement. SYSTEM.DBEFILE and SYSTEM.DBEFILESET contain
all the information about where tables are stored. You can use the following query to determine which DBEFileSet
contains a certain DBEFile:
isql=> SELECT DBEFName, DBEFSName FROM System.DBEFile
> WHERE DBEFName='PURCHDF1';
|
To determine the DBEFiles in a DBEFileSet, use the following query:
isql=> SELECT * FROM System.DBEFile
> WHERE DBEFSName='PURCHFS';
|
Table 8-12 System.DBEFile |
Column Name | Type | Length | Description |
|---|
| DBEFNAME | CHAR | 20 | Name of the DBEFile
| | DBEFTYPE | SMALLINT | 2 | Type: | | | | | 90 for mixed | | | | | 91 for index | | | | | 92 for data
| | FILEID | CHAR | 44 |
System identifier for the file
being used for the DBEFile
| | DBEFNPAGES | INTEGER | 4 | Number of pages in the DBEFile
| | DBEFUPAGES | INTEGER | 4 | Number of pages in the DBEFile containing table
and index data, excluding page table pages
| | DBEFINCRSZ | INTEGER | 4 | Number of pages the DBEFile
will be expanded each time
| | DBEFIPAGES | INTEGER | 4 | Number of pages in the DBEFile
at file creation time
| | DBEFMPAGES | INTEGER | 4 | Maximum number of pages the
DBEFile can be expanded
| | CTIME | CHAR | 16 | Time of creation: yyyymmddhhmmsstt
| | DBEFSNAME | CHAR | 20 | Name of the DBEFileSet the DBEFile
is associated with (if any)
| | DBEFNUMBER | INTEGER | 4 | Number of the DBEFileSet the
DBEFile is associated with
| | ATTACHED | CHARACTER | 2 | Whether the DBEFile is
attached to the DBEnvironment (Y for yes, N for no)
|
Example | |
SELECT * FROM System.DBEFile;
--------------------+--------+--------------------------------------------
DBEFNAME |DBEFTYPE|FILEID
--------------------+--------+--------------------------------------------
PARTSDBE0 | 90|PartsF0
PURCHDATAF1 | 92|PurchDF1
PURCHINDXF1 | 91|PurchXF1
WAREHDATAF1 | 92|WarehDF1
WAREHINDXF1 | 91|WarehXF1
ORDERDATAF1 | 92|OrderDF1
ORDERINDXF1 | 91|OrderXF1
FILEDATA | 92|FileData
RECDATAF1 | 90|RecDF1
NEWFILE | 90|NewFile
NEWFILE2 | 90|NewFile2
---------------------------------------------------------------------------
Number of rows selected is 11
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> r
+-----------+-----------+-----------+-----------+-----------
|DBEFNPAGES |DBEFUPAGES |DBEFINCRSZ |DBEFIPAGES |DBEFMPAGES
+-----------+-----------+-----------+-----------+-----------
| 150| 0| 0| 150| 150
| 50| 2| 0| 50| 50
| 50| 4| 0| 50| 50
| 50| 4| 0| 50| 50
| 50| 4| 0| 50| 50
| 50| 3| 0| 50| 50
| 50| 3| 0| 50| 50
| 50| 0| 0| 50| 50
| 50| 7| 0| 50| 50
| 150| 0| 0| 150| 150
| 100| 0| 0| 100| 100
---------------------------------------------------------------------------
Number of rows selected is 11
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> r
+----------------+---------------
|CTIME |DBEFSNAME
+----------------+---------------
|1990090614175200|SYSTEM
|1990090614192820|PURCHFS
|1990090614193170|PURCHFS
|1990090614194600|WAREHFS
|1990090614195400|WAREHFS
|1990090614200640|ORDERFS
|1990090614200990|ORDERFS
|1991020613192200|SYSTEM
|1993072014054600|RECFS
|1994021415230500|SYSTEM
|1994021415252200|
---------------------------------------------------------------------------
Number of rows selected is 11
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
+----------------+---------------
|DBEFNUMBER |ATTACHED
+----------------+---------------
| 0|Y
| 1|Y
| 2|Y
| 3|Y
| 4|Y
| 5|Y
| 6|Y
| 7|Y
| 8|Y
| 9|Y
| 10|Y
---------------------------------------------------------------------------
Number of rows selected is 11
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|
|
