User spaces store the user data in a SESAM/SQL database, i.e. the user tables and the indexes defined for those tables. From the point of view of the operating system, user spaces are ordinary BS2000 files.
Create user space
If the database, to which a user space is to be assigned, is stored on a DB user ID, the database administrator must make preparations for creating the new user space on this BS2000 user ID, see section “Database files and job variables on foreign user IDs”.
The database administrator creates a user space with the SQL statement CREATE SPACE. A maximum of 999 user spaces can be created per database.
A user space can be up to 4 TB in size on pubsets with “large files”. Otherwise it can be up to 64 GB in size.
Alter user space
The owner of a user space can modify the space with the SQL statement ALTER SPACE.
ALTER SPACE can be used to modify the free-space reservation and to disable DA logging. In addition, a new storage group can be specified for the user space in the USING clause. To do this, the owner of the user space requires the special privilege USAGE ON STOGROUP for the new storage group (see section “Special privileges” ). A change to the free-space reservation takes effect the next time the user space is reorganized. The change takes effect before this:
in the case of IMPORT TABLE, if tables are imported together with their user data,
in the case of LOAD OFFLINE, if data is loaded into an empty table or if new data is appended to existing data.
A change to the storage group takes effect the next time the user space is reorganized.
Delete user space
The owner of a user space can delete the space with the SQL statement DROP SPACE.