Altering catalog space

The universal user can alter the catalog space using the SQL statement ALTER SPACE "CATALOG" (CATALOG in double quotes).

ALTER SPACE enables the free-space reservation to be altered and a new storage group to be specified for the catalog space. If the storage group is altered, the universal user must have the special privilege USAGE for the new storage group.

The alterations become effective the next time the catalog space is reorganized.