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

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