beautypg.com

HP Neoview Release 2.4 Software User Manual

Page 58

background image

Table 3-11 SPACE_PARTITION_DETAIL_VW1 Field Definitions (continued)

Description

Data Type

Field Name

Size allocated by the file system

LARGEINT

ALLOCATED_SIZE_BYTES

Percentage of disk space currently in use

NUMERIC(128, 2)

FULL_PCT

VIEW NEO.HP_METRICS.SPACE_PARTITION_DETAIL_HISTORY_VW1

The Space Management Client in HPDM accesses this view to obtain aging historical data about
the table partitions. You can also run queries directly against this view. For sample queries, see

“Sample Query Views for Space Management” (page 62)

.

Table 3-12 SPACE_PARTITION_DETAIL_HISTORY_VW1 Field Definitions

Description

Data Type

Field Name

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 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 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

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

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

58

Repository Views