HP Neoview Release 2.4 Software - Manual (Page 56)

Table 3-11 SPACE_PARTITION_DETAIL_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
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
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
56 Repository Views