HP Neoview Release 2.5 Software - Manual (Page 49)

Table 3-8 SPACE_PARTITION_DETAIL_VW1 Field Definitions (continued)
Description Data Type Field Name
Crash open. For disk objects other than SQL
shorthand views:
1 = if the object was open with write access
when a system failure occurred and the
object has not been opened since
0 = otherwise
CHAR(1) CRASH_OPEN
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
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
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
Space Management Views and Sample Query Views for Space Management 49