HP Neoview Release 2.4 Software - Manual (Page 49)

Aggregates represent differences between the previous aggregation period and the current
aggregation period.
In the case of an NDCS server process or a Neoview SQL compiler process, statistics are not
really aggregates because each record represents only one process.
In this view, all CHARACTER columns use ISO88591 encoding, regardless of the underlying
Neoview platform configuration.
The primary key for PROCESS_AGGR_LEVEL1_STATS_V1 field definition is SEGMENT_ID,
NODE_ID, PIN, and SAMPLE_DATETIME_UTC.
Table 3-9 PROCESS_AGGR_LEVEL1_STATS_V1 Field Definitions
Description Data Type Field Name
Segment number of the
parent process SMALLINT UNSIGNED SEGMENT_ID
ANSI SQL timestamp of
the aggregation, in Local
Civil Time. TIMESTAMP(6) SAMPLE_DATETIME
ANSI SQL date of the
aggregation, in Local
Civil Time. DATE SAMPLE_DATE
ANSI SQL time of the
aggregation, in Local
Civil Time. TIME(6) SAMPLE_TIME
ANSI SQL timestamp of
the aggregation, in
Coordinated Universal
Time. TIMESTAMP(6) SAMPLE_DATETIME_UTC
ANSI SQL date of the
aggregation, in
Coordinated Universal
Time. DATE SAMPLE_DATE_UTC
ANSI SQL time of the
aggregation, in
Coordinated Universal
Time. TIME(6) SAMPLE_TIME_UTC
Processing node number
of the parent process SMALLINT UNSIGNED NODE_ID
Unique number
representing a running
instance of a process, in
this case the parent
process, or “unknown.” SMALLINT UNSIGNED PIN
“MXCMP ” for the SQL
compiler, “MXESP ” for
the SQL executor server
process, “MXOSRVR ”
for the NDCS server,
“MMCOLLEC ” for the
Repository collector CHARACTER(8) METRIC_TYPE
Neoview segment name CHARACTER(8) SEGMENT_NAME
Object file name of the
process type for which
statistics are aggregated
in this record, e.g.,
$SYSTEM.SYSTEM.MXESP CHARACTER(24) CHILD_PROGRAM_FILE_NAME
Process Statistics 49