Each row in the SYSDBFILE system view describes a dbspace file. The underlying system table for this view is ISYSDBFILE.
| Column name | Data type | Description |
|---|---|---|
| dbfile_id | SMALLINT | For internal use only. |
| dbspace_id | SMALLINT | Each dbspace file in a database is assigned a unique number. The system dbspace contains all system objects and has a dbspace_id of 0. |
| dbfile_name | CHAR(128) |
The file name for the dbspace. |
| file_name | LONG VARCHAR | A unique name for the dbspace. It is used in the CREATE TABLE command. |
| lob_map | LONG VARBIT | For internal use only. |
| server_id | UNSIGNED INT (nullable) | The ID of the physical server where the DAS dbfile exists. Applies to shared-nothing multiplex architecture. |
PRIMARY KEY (dbfile_id)
FOREIGN KEY (dbspace_id) REFERENCES SYS.ISYSDBSPACE (dbspace_id)
UNIQUE index file_name( file_name, server_id )