SYS_SPACES

Information on spaces.

Column name

Data type

Contents

SPACE_NAME

CHAR (18)

Name of the space

SPACE_NAME_SHORT

CHAR (12)

First 12 characters of the space name

SPACE_ID

SMALLINT

Identification number of the space

SPACE_OWNER

CHAR (18)

Authorization identifier that owns the
space

STOGROUP_NAME

CHAR (18)

Name of the storage group for the space

PCT_FREE

SMALLINT

Free space reservation in percent

DELTA_STOGROUP

CHAR (1)

Y	Space stored on storage group STOGROUP_NAME
N	Space not yet stored on the storage group STOGROUP_NAME newly assigned with ALTER SPACE

SPACE_DATE

TIMESTAMP (3)

Time of creation or time at which the
definition of the tables and indexes on the
space were last updated

LOGGING

VARCHAR (3)

YES	Logging activated
NO	Logging deactivated

The data for STOGROUP_NAME and PCT_FREE can be modified with ALTER SPACE;
this data is not actually taken into account until RECOVER or REORG is executed.

Table 130: SYS_SPACES view of the SYS_INFO_SCHEMA