beautypg.com

View neo.hp_metrics.space_partition_detail_vw1, Space_partition_detail_vw1 field definitions, Space management – HP Neoview Release 2.4 Software User Manual

Page 55

background image

Table 3-10 EVENTS_VW1 Field Definitions (continued)

Description

Data Type

Field Name

File system error, if related to
an SQL error. Null for any other
event.

INTEGER, nullable

FSERROR

Text description of the EMS
event.
If the Neoview platform is
configured for UTF8 or SJIS
character sets, this column uses
UCS2. Otherwise, this column
uses the ISO88591 character set.

VARCHAR(5000)

TEXT

Space Management Views and Sample Query Views for Space
Management

If you need more reports than what Space Management in HPDM provides, you can run queries
directly against the Repository views for space management. See these next sections for details:

“VIEW NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1” (page 55)

“VIEW NEO.HP_METRICS.SPACE_PARTITION_DETAIL_HISTORY_VW1” (page 58)

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

VIEW NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1

The Space Management Client in HPDM accesses this view to obtain inventory 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-11 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

Space Management Views and Sample Query Views for Space Management

55