CREATE TABLE SYS.SYSFILE ( file_id SMALLINT NOT NULL, file_name LONG VARCHAR NOT NULL, dbspace_name CHAR(128) NOT NULL, store_type CHAR(8) NOT NULL, PRIMARY KEY ( file_id ) )
Every database consists of one or more operating system files. Each file is recorded in SYSFILE.
file_id Each file in a database is assigned a unique number. This file identifier is the primary key for SYSFILE. All system tables are stored in file_id 0.
file_name The database name is stored when a database is created. This name is for informational purposes only. For the SYSTEM dbspace, the file name always reflects the name when the data base was created. Changes to the file name are not reflected here.
dbspace_name Every file has a dbspace name that is unique. It is used in the CREATE TABLE command.
store_type Defines the file as belonging to either the Catalog Store (SA) or the IQ STORE.
