View neo.hp_metrics.space_partition_detail_vw1 – HP Neoview Release 2.5 Software User Manual
Page 47
Table 3-7 EVENTS_VW1 Field Definitions (continued)
Description
Data Type
Field Name
Instance number of the process
that generated the event.
INTEGER UNSIGNED
PROCESS_ID_INSTANCE
Processing node number of the
process that generated the
event.
INTEGER UNSIGNED
NODE_ID
Process identification number
of the process that generated
the event.
INTEGER UNSIGNED
PIN
Segment number of the process
that generated the event. For
example, 1 for segment
\NEO0101 or 3 for segment
\NEO0103.
INTEGER UNSIGNED
SEGMENT_ID
Reserved for future expansion
Reserved for future expansion
START_ENTRY_ID
Reserved for future expansion
Reserved for future expansion
START_ENTRY_ID
SQL error code. Null if event is
not SQL-related.
INTEGER, nullable
SQLCD
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 47)
•
“VIEW NEO.HP_METRICS.SPACE_PARTITION_DETAIL_HISTORY_VW1” (page 50)
•
“Sample Query Views for Space Management” (page 54)
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 54)
.
Space Management Views and Sample Query Views for Space Management
47