Process statistics, View neo.hp_metrics.process_stats_v1 – HP Neoview Release 2.4 Software User Manual
Page 40
Table 3-5 NODE_STATS_V1 Field Definitions (continued)
Description
Data Type
Field Name
Number of free memory frames
(physical pages) when the
processing node was loaded.
LARGEINT
STARTING_FREE_MEM
Number of free memory frames
(physical pages) at the end of the
measurement interval.
LARGEINT
ENDING_FREE_MEM
Number of bytes read by this
processing node, if NODE_ID is
1. Othewise, this field is not
populated.
LARGEINT
SVNET_READ_BYTES1
Number of bytes written by this
processing node, if NODE_ID is
1. Othewise, this field is not
populated.
LARGEINT
SVNET_WRITE_BYTES1
Number of bytes read by this
processing node, if NODE_ID is
16. Othewise, this field is not
populated.
LARGEINT
SVNET_READ_BYTES16
Number of bytes written by this
processing node, if NODE_ID is
16. Othewise, this field is not
populated.
LARGEINT
SVNET_WRITE_BYTES16
Process Statistics
The two views used for access to process statistics differ in that one includes a record for each
measured process, whereas the other aggregates information about measured processes of specific
types. If process data collection is enabled, both views are populated with data.
NOTE:
The process statistics are not turned on by default and are scheduled to be deprecated.
If you want HP Support to enable it, please contact your HP Support representative.
The measurements apply to four key process types:
•
The Neoview SQL compiler (MXCMP)
•
The Neoview SQL executor server process (MXESP)
•
The Neoview NDCS server (MXOSRVR)
•
The Repository collector processes (MMCOLLEC)
By default, a measurement of each of these processes occurs every five minutes. Aggregates are
computed every five minutes with a 15–minute delay: that is, aggregate data becomes available
from the Repository 15 minutes after the end of the sampling interval.
VIEW NEO.HP_METRICS.PROCESS_STATS_V1
NOTE:
The process statistics are not turned by default and are scheduled to be deprecated.
This view is populated only if process data collection is enabled.
In this view, all CHARACTER columns use ISO88591 encoding, regardless of the underlying
Neoview platform configuration.
The primary key for PROCESS_STATS_V1 field definition is SEGMENT_ID, NODE_ID, PIN,
and METRIC_CLASS_ID.
40
Repository Views