HP Neoview Release 2.4 Software - Manual (Page 59)

Table 3-12 SPACE_PARTITION_DETAIL_HISTORY_VW1 Field Definitions (continued)
Description Data Type Field Name
Object type, which can be:
BT (Base Table)
MV (Materialized View)
IX (Index)
CHAR(2) OBJECT_TYPE
Type of aggregation in the row:
H (Hourly Aggregation Row)
D (Daily Aggregation Row)
W (Weekly Aggregation Row)
M (Monthly Aggregation Row)
Q (Quarterly Aggregation Row)
Y (Yearly Aggregation Row)
CHAR(1) ROW_TYPE
Indicates whether the row is the most
granular row for any given time period. For
future use. CHAR(1) MOST_GRANULAR
Indicates whether the row is the least
granular row for any given time period. For
future use. CHAR(1) LEAST_GRANULAR
Subvolume and simple name of a file with
a partition CHAR(17) FILE_NAME
Disk volume name CHAR(8) DISK_NAME
Corrupt. For disk objects other than SQL
shorthand views:
1 = if the object has the corrupt flag set
0 = otherwise
CHAR(1) CORRUPT_BROKEN_CURR
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_CURR
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
Space Management Views and Sample Query Views for Space Management 59