SYS_SPACE_PROPERTIES

Information on space properties. In the case of spaces that are not currently open, only some of the properties will be output.

Column name	Data type	Contents
SPACE_NAME	CHAR (18)	Name of the space
PROPERTY_NAME	CHAR (31)	Name of the space property The following properties are output: SPACE_ID is the space number determined from the catalog. SPACE_TIMESTAMP specifies the time at which the space was last modified. CHECK_TIMESTAMP specifies the time against which the consistency of the space is checked. MAX_POSSIBLE_PAGE is the highest possible page number of the space 1.073.741.822 (X'3FFFFFFE') for spaces up to 4 TB 16.777.214 (X'00FFFFFE') for spaces up to 64 GB LAST_USED_PAGE is the last logically occupied 4K-page of the space. SPACE_LOCK_RECOVER_PENDING specifies whether or not the space could be restored during the repair SPACE_LOCK_LOAD_RUNNING specifies whether or not the loading of data into a base table of the space using LOAD or IMPORT TABLE has completed. SPACE_LOCK_IS_COPY specifies whether the space’s backup copy is mounted and therefore only read access is permitted. SPACE_LOCK_IS_REPLICATE specifies whether the space’s replicate is mounted and therefore only read access is permitted. SPACE_LOCK_COPY_PENDING specifies whether the space is locked against updates due to a pending COPY cmd. SPACE_LOCK_CHECK_PENDING specifies whether the integrity constraints have been checked following the loading of data into a base table using LOAD. SPACE_LOCK_REORG_PENDING specifies that the maximum space size has been reached. Only read accesses and DELETE and REORG SPACE are therefore permitted. SPACE_FLAG_OPENED specifies whether the space is open. SPACE_FLAG_MODIFIED specifies whether the space has been modified. SPACE_FLAG_DEFECT specifies whether the space is defective. OPEN_TIMESTAMP specifies the time at which the space was last physically opened. The BLOCK_DENSITY_xx fields describe the number of blocks whose density factor was found to be greater than (xx-10)% and less than or equal to xx% since OPEN_TIMESTAMP: BLOCK_DENSITY_10 BLOCK_DENSITY_20 . . . BLOCK_DENSITY_90 BLOCK_DENSITY_100
CHARACTER_VALUE	VARCHAR (256)	Value of the space property NULL value If INTEGER_VALUE is a value other than NULL
INTEGER_VALUE	INTEGER	Value of the space property NULL value If CHARACTER_VALUE is a value other than NULL

Table 131: SYS_SPACE_PROPERTIES view of the SYS_INFO_SCHEMA (section 3 of 3)