beautypg.com

View neo.hp_metrics.process_aggr_level1_stats_v1, Process_aggr_level1_stats_v1 field definitions – HP Neoview Release 2.5 Software User Manual

Page 78

background image

Table C-1 PROCESS_STATS_V1 Field Definitions (continued)

Description

Data Type

Field Name

Number of calls to open regular files,
pipes, FIFOs, AF_INET sockets,
AF_UNIX sockets, directories, and
other files, including implicit opens
due to process creation APIs

LARGEINT

FILE_OPEN_CALLS

Number of times the process began a
transaction

LARGEINT

BEGIN_TRANS

Number of times the process stopped
a transaction in progress, causing the
transaction to be rolled back

LARGEINT

ABORT_TRANS

Number of pages in main memory
sponsored by the measured process at
the start of the measurement interval

LARGEINT

PRES_PAGES_START

Number of pages in main memory
sponsored by the measured process at
the end of the measurement interval

LARGEINT

PRES_PAGES_END

Time, in microseconds, that messages
sent by the process were outstanding

LARGEINT

MSGS_SENT_QUE_TIME

VIEW NEO.HP_METRICS.PROCESS_AGGR_LEVEL1_STATS_V1

NOTE:

Process statistics are not turned on by default. If you want HP Support to enable process

statistics, please contact your HP Support representative.

Each row of this view represents statistics, or aggregate statistics, for one of the following processes
or sets of processes:

All executor server processes for a given parent (NDCS server) process.

All Repository collector processes for a given parent process.

Each NDCS server process.

Each Neoview SQL compiler process. In the case of a compiler process, the parent process
will not be identified in the Repository record.

This view is populated only if process data collection is enabled.
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 C-2 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

78

Repository Views Disabled by Default