beautypg.com

Space_partition_detail_vw1 field definitions – HP Neoview Release 2.5 Software User Manual

Page 48

background image

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