HP Neoview Release 2.5 Software - Manual (Page 51)

Table 3-9 SPACE_PARTITION_DETAIL_HISTORY_VW1 Field Definitions (continued)
Description Data Type Field Name
Neoview system name, made up of the first
three letters of the system name, followed
by 01 for the first platform at your site, 02
for the second platform at your site, and so
on.
Example: NEO01
CHAR(64) PLATFORM_NAME
Segment number
Example: 1
INT SEGMENT_ID
Segment name
Example: \NEO0101
CHAR(64) SEGMENT_NAME
Catalog name VARCHAR(128) CATALOG_NAME
Schema name VARCHAR(128) SCHEMA_NAME
Object name VARCHAR(128) OBJECT_NAME
Object namespace
Example: TA for tables and IX for indexes
CHAR(2) OBJECT_NAME_SPACE
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
Space Management Views and Sample Query Views for Space Management 51