Neoview Repository User Guide (R2.4 SP2)

Table 3-4 ODBC_SESSION_STATS_V2 Fields (continued)
Source and NotesData TypeIncomplete SessionsComplete Sessions
END, or NULL for an incomplete
session
LARGEINTTOTAL_PREPARES
END, or NULL for an incomplete
session
LARGEINTTOTAL_SELECT_STMTS_EXECUTED
END, or NULL for an incomplete
session
LARGEINTTOTAL_UPDATE_STMTS_EXECUTED
END, or NULL for an incomplete
session
LARGEINTTOTAL_WARNINGS
Processing Node Statistics
The Repository stores one row for each probe of a processing node (CPU). By default, the probe
interval is five minutes.
NOTE: A probe, in this context, is a statistics gathering session initiated by the Repository.
VIEW NEO.HP_METRICS.NODE_STATS_V1
Except where noted, processing-node counters are allocated and initialized only when the
processing node is loaded—when the platform is started or a processing node is restarted for
any reason—not at the start of each measurement.
All CHARACTER fields contain ISO88591-encoded data, regardless of the underlying Neoview
platform configuration.
The primary key for the NODE_STATS_V1 field definition is SEGMENT_ID, NODE_ID, and
MEASURE_END_DATETIME_UTC.
Table 3-5 NODE_STATS_V1 Field Definitions
DescriptionData TypeField Name
Segment number of the
processing node being
measured.
INTEGER UNSIGNEDSEGMENT_ID
Processing node number.INTEGER UNSIGNEDNODE_ID
ANSI SQL timestamp, in Local
Civil Time, indicating when the
measurement interval ended.
TIMESTAMP(6)MEASURE_END_DATETIME
ANSI SQL date, in Local Civil
Time, indicating when the
measurement interval ended.
DATEMEASURE_END_DATE
ANSI SQL time, in Local Civil
Time, indicating when the
measurement interval ended.
TIME(6)MEASURE_END _TIME
ANSI SQL timestamp, in
Coordinated Universal Time,
indicating when the
measurement interval ended.
TIMESTAMP(6)MEASURE_END _DATETIME_UTC
ANSI SQL date, in Coordinated
Universal Time, indicating when
the measurement interval ended.
DATEMEASURE_END _DATE_UTC
38 Repository Views