SPACES

Information on the spaces that belong to the current authorization identifier, and which the current authorization identifier can access via utilities.

Column name

Data type

Contents

SPACE_CATALOG

CHAR (18)

Database name

SPACE_NAME

CHAR (18)

Name 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

LOGGING

VARCHAR (3)

YES	Logging activated
NO	Logging deactivated

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

Table 89: SPACES view of the INFORMATION_SCHEMA