HP Neoview Release 2.4 Software - Manual (Page 61)

Table 3-12 SPACE_PARTITION_DETAIL_HISTORY_VW1 Field Definitions (continued)
Description Data Type Field Name
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
Timestamp, in Local Civil Time, when the
partition was last modified LARGEINT LAST_MODIFIED_LCT_JTS
Timestamp, in Local Civil Time, when the
partition was last opened LARGEINT LAST_OPEN_LCT_JTS
Timestamp, in Local Civil Time, when the
partition was dropped LARGEINT DROP_TIME_LCT_JTS
The application-defined code INT UNSIGNED FILE_CODE
Owner of the file CHAR(64) FILE_OWNER_NAME
One of these categories:
SQL Permanent Space
SQL System Space
SQL Volatile Space
Transform Ghost Objects
Transporter Staging Tables
CHAR(128) CATEGORY_TYPE
User or System CHAR(20) CATEGORY_NAME
Size allocated by the file system LARGEINT ALLOCATED_SIZE_BYTES
Percentage of disk space currently in use NUMERIC(128, 2) FULL_PCT
Space Management Views and Sample Query Views for Space Management 61