HP Neoview Release 2.3 Software - Manual (Page 47)

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.
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
Minimum creation
priority for all processes
described by this record INTEGER UNSIGNED MIN_PRIORITY
Process Statistics 47