HP Neoview Release 2.4 Software - Manual (Page 43)

Table 3-6 ODBC_SESSION_STATS_V2 Fields (continued)
Source and
Notes
Data Type Incomplete Sessions Complete Sessions
END, or
NULL for an
incomplete
session LARGEINT TOTAL_MASTER_EXEC_EXECUTION_TIME
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-7 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
Processing Node Statistics 43