beautypg.com

View neo.hp_metrics.space_partition_detail_vw1 – HP Neoview Release 2.5 Software User Manual

Page 47

background image

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