HP Neoview Release 2.4 Software - Manual (Page 38)

Table 3-4 ODBC_SESSION_STATS_V2 Fields (continued)
Source and Notes Data Type Incomplete Sessions Complete Sessions
END, or NULL for an incomplete
session LARGEINT TOTAL_PREPARES
END, or NULL for an incomplete
session LARGEINT TOTAL_SELECT_STMTS_EXECUTED
END, or NULL for an incomplete
session LARGEINT TOTAL_UPDATE_STMTS_EXECUTED
END, or NULL for an incomplete
session LARGEINT TOTAL_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
Description Data Type Field Name
Segment number of the
processing node being
measured. INTEGER UNSIGNED SEGMENT_ID
Processing node number. INTEGER UNSIGNED NODE_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. DATE MEASURE_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. DATE MEASURE_END _DATE_UTC
38 Repository Views