HP Neoview Release 2.5 Software - Manual (Page 53)

Table 3-9 SPACE_PARTITION_DETAIL_HISTORY_VW1 Field Definitions (continued)
Description Data Type Field Name
Minimum value of ALLOC_EXTENT_CURR LARGEINT ALLOC_EXTENT_MIN
Maximum value of ALLOC_EXTENT_CURR LARGEINT ALLOC_EXTENT_MAX
Record length in bytes LARGEINT RECORD_LEN_CURR_BYTES
Average value of
RECORD_LEN_CURR_BYTES LARGEINT RECORD_LEN_AVG_BYTES
Minimum value of
RECORD_LEN_CURR_BYTES LARGEINT RECORD_LEN_MIN_BYTES
Maximum value of
RECORD_LEN_CURR_BYTES LARGEINT RECORD_LEN_MAX_BYTES
Row count of the last UPDATE STATISTICS
operation LARGEINT STATS_ROWCOUNT_CURR_NUM
Average value of
STATS_ROWCOUNT_CURR LARGEINT STATS_ROWCOUNT_AVG_NUM
Minimum value of
STATS_ROWCOUNT_CURR LARGEINT STATS_ROWCOUNT_MIN_NUM
Maximum value of
STATS_ROWCOUNT_CURR LARGEINT STATS_ROWCOUNT_MAX_NUM
Timestamp, in Coordinated Universal Time,
when UPDATE STATISTICS was last run LARGEINT STATS_CURR_UTC_JTS
Timestamp, in Local Civil Time, when
UPDATE STATISTICS was last run LARGEINT STATS_CURR_LCT_JTS
Index level of the last UPDATE STATISTICS
operation LARGEINT INDEX_LEVELS_CURR
Average value of INDEX_LEVELS_CURR LARGEINT INDEX_LEVELS_AVG
Minimum value of INDEX_LEVELS_CURR LARGEINT INDEX_LEVELS_MIN
Maximum value of INDEX_LEVELS_CURR LARGEINT INDEX_LEVELS_MAX
Real row-count number, available only when
the ROWC flag is set to Y LARGEINT ROW_COUNT_CURR_NUM
Average value of
ROW_COUNT_CURR_NUM LARGEINT ROW_COUNT_AVG_NUM
Minimum value of
ROW_COUNT_CURR_NUM LARGEINT ROW_COUNT_MIN_NUM
Maximum value of
ROW_COUNT_CURR_NUM LARGEINT ROW_COUNT_MAX_NUM
Timestamp, in Coordinated Universal Time,
when the partition was created LARGEINT CREATE_UTC_JTS
Timestamp, in Coordinated Universal Time,
when the partition was last modified LARGEINT LAST_MODIFIED_UTC_JTS
Timestamp, in Coordinated Universal Time,
when the partition was last opened LARGEINT LAST_OPEN_UTC_JTS
Timestamp, in Coordinated Universal Time,
when the partition was dropped LARGEINT DROP_TIME_UTC_JTS
Timestamp, in Local Civil Time, when the
partition was created LARGEINT CREATE_LCT_JTS
Space Management Views and Sample Query Views for Space Management 53