Space_partition_detail_vw1 field definitions – HP Neoview Release 2.5 Software User Manual
Page 48
Table 3-8 SPACE_PARTITION_DETAIL_VW1 Field Definitions
Description
Data Type
Field Name
Timestamp, in Local Civil Time, indicating
when this row was updated in the
Repository
Example: 2010-01-26 07:47:28.795392
LARGEINT
LAST_UPDATE_LCT_JTS
Timestamp, in Local Civil Time, indicating
when information in this row was checked
against the system values but did not need
any Repository update
Example: 2010-01-26 07:48:09.967095
LARGEINT
LAST_CHECK_NOUPDATE_LCT_JTS
Timestamp, in Coordinated Universal Time,
indicating when this row was updated in the
Repository
Example: 2010-01-26 15:47:28.795392
LARGEINT
LAST_UPDATE_UTC_JTS
Timestamp, in Coordinated Universal Time,
indicating when information in this row was
checked against the system values but did
not need any Repository update
Example: 2010-01-26 15:48:09.967095
LARGEINT
LAST_CHECK_NOUPDATE_UTC_JTS
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
48
Repository Views