beautypg.com

HP Neoview Release 2.5 Software User Manual

Page 79

background image

Table C-2 PROCESS_AGGR_LEVEL1_STATS_V1 Field Definitions (continued)

Description

Data Type

Field Name

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

Average creation priority all
processes described by this
record

INTEGER UNSIGNED

AVG_PRIORITY

Maximum creation priority for
all processes described by this
record

INTEGER UNSIGNED

MAX_PRIORITY

Number of processes included
in this aggregation

INTEGER UNSIGNED

CHILD_COUNT

Sum of elapsed times, in
microseconds, between the end
of the last aggregation period
and the end of this one, for all
processes described by this
record

LARGEINT

TOTAL_CHILD_ELAPSED_TIME

Sum of CPU busy time, in
microseconds, for all processes
described by this record, since
the last aggregation

LARGEINT

TOTAL_CHILD_BUSY_TIME

Process Statistics

79