To create physical storage, you use data definition statements to create the following storage areas:
File space for tables and indexes is managed by adding and
dropping DBEFiles from DBEFileSets.
DBEFiles are units of physical storage and DBEFileSets are logical
collections of DBEFiles.
You use the CREATE DBEFILESET statement to define a DBEFileSet,
and the CREATE DBEFILE statement to define DBEFiles. You associate
physical storage with the DBEFileSet by associating
DBEFiles with it, using the ADD DBEFILE statement.
CREATE DBEFILESET WarehFS
CREATE DBEFILE WarehD1 WITH PAGES = 50, NAME = 'WarehD1'
ADD DBEFILE WarehD1 TO DBEFILESET WarehFS
|
Once you have created DBEFileSets and added DBEFiles to them,
you need to specify the
name of a DBEFileSet in your table creation statements.
This then defines, for that table, the physical files that will be
used to store the data. For complete details about creating
DBEFiles and DBEFileSets, refer to the ALLBASE/SQL Database Administration Guide.
TempSpace can be optionally defined and is a specific area of
storage used by the system for performing sorts in the database.
TempSpaces are created and dropped by using the CREATE TEMPSPACE
and DROP TEMPSPACE statements.
Temporary files are allocated under the available TempSpaces as they are needed
for performing a sort, and deallocated once the sort is completed.
TempSpace information
is accessible through the system catalog view SYSTEM.TEMPSPACE.
A TempSpace is referred to by a unique name. If a TempSpace is not defined, sorting is done in the
current group.