SYSTEM.SPACEDEFAULT contains the default
TABLESPACE and SECTIONSPACE DBEFileSets for PUBLIC.
Initially SYSTEM.SPACEDEFAULT contains two rows, one having the column values
PUBLIC, SYSTEM, 1 and the other having the column values PUBLIC, SYSTEM, 2.
Thus SYSTEM is the default DBEFileSet for table, long column, and
section data for PUBLIC.
ALLBASE/SQL accesses SYSTEM.SPACEDEFAULT whenever a table, long column,
rule, check constraint, procedure, or section
(generated by a PREPARE, DECLARE CURSOR, or CREATE VIEW statement)
is created without the IN DBEFileSetNAME clause.
Table 8-34 System.Spacedefault
Column Name
|
Type
|
Length
|
Description |
---|
USERID
|
CHAR
|
20
|
Authorized DBEUserID or
authorization group
|
DBEFILESET
|
CHAR
|
20
|
Name of a DBEFileSet
|
SPACETYPE
|
SMALLINT
|
2
| Type of default DBEFileSet:
1 (SECTIONSPACE)
2 (TABLESPACE)
|
Example |
 |
select * FROM System.Spacedefault;
--------------------+--------------------+---------
USERID |DBEFILESET |SPACETYPE
--------------------+--------------------+---------
PUBLIC |SYSTEM | 1
PUBLIC |SYSTEM | 2
--------------------------------------------------------------------------
Number of rows selected is 2
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|