HP Neoview Release 2.4 Software - Manual (Page 57)

Table 3-11 SPACE_PARTITION_DETAIL_VW1 Field Definitions (continued)
Description Data Type Field Name
Current data size, in bytes, of the partition,
determined by the End of File (EOF)
indicator LARGEINT SIZE_CURR_BYTES
Maximum size, in bytes, of the partition LARGEINT MAX_SIZE_CURR_BYTES
Primary extent size in bytes LARGEINT PRIMARY_EXTENT_CURR
Secondary extent size in bytes LARGEINT SECONDARY_EXTENT_CURR
Maximum extent size in bytes LARGEINT MAX_EXTENT_CURR
Allocated extent number LARGEINT ALLOC_EXTENT_CURR
Record length in bytes LARGEINT RECORD_LEN_CURR_BYTES
Row count of the last UPDATE STATISTICS
operation LARGEINT STATS_ROWCOUNT_CURR_NUM
Timestamp, in Local Civil Time, when
UPDATE STATISTICS was last run LARGEINT STATS_CURR_LCT_JTS
Timestamp, in Coordinated Universal Time,
when UPDATE STATISTICS was last run LARGEINT STATS_CURR_UTC_JTS
Index level of the last UPDATE STATISTICS
operation LARGEINT INDEX_LEVELS_CURR
Real row-count number, available only when
the ROWC flag is set to Y LARGEINT ROW_COUNT_NUM
Timestamp, in Local Civil Time, when the
partition was created LARGEINT CREATE_LCT_JTS
Timestamp, in Coordinated Universal Time,
when the partition was created LARGEINT CREATE_UTC_JTS
Timestamp, in Local Civil Time, when the
partition was last modified LARGEINT LAST_MODIFIED_LCT_JTS
Timestamp, in Coordinated Universal Time,
when the partition was last modified LARGEINT LAST_MODIFIED_UTC_JTS
Timestamp, in Local Civil Time, when the
partition was last opened LARGEINT LAST_OPEN_LCT_JTS
Timestamp, in Coordinated Universal Time,
when the partition was last opened LARGEINT LAST_OPEN_UTC_JTS
Timestamp, in Local Civil Time, when the
partition was dropped LARGEINT DROP_TIME_LCT_JTS
Timestamp, in Coordinated Universal Time,
when the partition was dropped LARGEINT DROP_TIME_UTC_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
Space Management Views and Sample Query Views for Space Management 57