HP Neoview Release 2.5 Software - Manual (Page 52)

Table 3-9 SPACE_PARTITION_DETAIL_HISTORY_VW1 Field Definitions (continued)
Description Data Type Field Name
Incomplete SQL DDL operation. For SQL
tables and indexes:
1 = if the object has the D flag set
0 = otherwise
The D flag is an internal setting for
incomplete SQL DDL operations.
CHAR(1) INCOMPLETE_SQL_DDL_CURR
Unreclaimed free space. For SQL tables and
indexes:
1 = if the object has the F flag set
0 = otherwise
The F flag is an internal setting for unclaimed
free space.
CHAR(1) UNRECLAIMED_FREE_SPACE_CURR
Current data size, in bytes, of the partition,
determined by the End of File (EOF)
indicator LARGEINT SIZE_CURR_BYTES
Average value of SIZE_CURR_BYTES LARGEINT SIZE_AVG_BYTES
Minimum value of SIZE_CURR_BYTES LARGEINT SIZE_MIN_BYTES
Maximum value of SIZE_CURR_BYTES LARGEINT SIZE_MAX_BYTES
Maximum size, in bytes, of the partition LARGEINT MAX_SIZE_CURR_BYTES
Average value of MAX_SIZE_CURR_BYTES LARGEINT MAX_SIZE_AVG_BYTES
Minimum value of
MAX_SIZE_CURR_BYTES LARGEINT MAX_SIZE_MIN_BYTES
Maximum value of
MAX_SIZE_CURR_BYTES LARGEINT MAX_SIZE_MAX_BYTES
Primary extent size in bytes LARGEINT PRIMARY_EXTENT_CURR
Average value of
PRIMARY_EXTENT_CURR LARGEINT PRIMARY_EXTENT_AVG
Minimum value of
PRIMARY_EXTENT_CURR LARGEINT PRIMARY_EXTENT_MIN
Maximum value of
PRIMARY_EXTENT_CURR LARGEINT PRIMARY_EXTENT_MAX
Secondary extent size in bytes LARGEINT SECONDARY_EXTENT_CURR
Average value of
SECONDARY_EXTENT_CURR LARGEINT SECONDARY_EXTENT_AVG
Minimum value of
SECONDARY_EXTENT_CURR LARGEINT SECONDARY_EXTENT_MIN
Maximum value of
SECONDARY_EXTENT_CURR LARGEINT SECONDARY_EXTENT_MAX
Maximum extent size in bytes LARGEINT MAX_EXTENT_CURR
Average value of MAX_EXTENT_CURR LARGEINT MAX_EXTENT_AVG
Minimum value of MAX_EXTENT_CURR LARGEINT MAX_EXTENT_MIN
Maximum value of MAX_EXTENT_CURR LARGEINT MAX_EXTENT_MAX
Allocated extent number LARGEINT ALLOC_EXTENT_CURR
Average value of ALLOC_EXTENT_CURR LARGEINT ALLOC_EXTENT_AVG
52 Repository Views