Neoview Repository User Guide (R2.4 SP1)

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-11 PROCESS_AGGR_LEVEL1_STATS_V1 Field Definitions
DescriptionData TypeField Name
Segment number of the parent
process
SMALLINT UNSIGNEDSEGMENT_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.
DATESAMPLE_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.
DATESAMPLE_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 UNSIGNEDNODE_ID
Unique number representing a
running instance of a process, in
this case the parent process, or
“unknown.”
SMALLINT UNSIGNEDPIN
“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 nameCHARACTER(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 UNSIGNEDMIN_PRIORITY
Average creation priority all
processes described by this record
INTEGER UNSIGNEDAVG_PRIORITY
Maximum creation priority for all
processes described by this record
INTEGER UNSIGNEDMAX_PRIORITY
Number of processes included in
this aggregation
INTEGER UNSIGNEDCHILD_COUNT
62 Repository Views