C repository views disabled by default, Process statistics, View neo.hp_metrics.process_stats_v1 – HP Neoview Release 2.5 Software User Manual
Page 75: Process_stats_v1 field definitions, Appendix c: “repository, Appendix c: repository views disabled by default
C Repository Views Disabled by Default
This appendix contains the following views that have been disabled by default:
•
“VIEW NEO.HP_METRICS.PROCESS_STATS_V1” (page 75)
•
“VIEW NEO.HP_METRICS.PROCESS_AGGR_LEVEL1_STATS_V1” (page 78)
•
“VIEW NEO.HP_METRICS.TABLE_STATS_V2 and VIEW
NEO.HP_METRICS.TABLE_STATS_DETAIL_V2” (page 83)
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:
Process statistics are not turned on by default. If you want HP Support to enable process
statistics, 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:
Process statistics are not turned on by default. If you want HP Support to enable process
statistics, please contact your HP Support representative.
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.
Table C-1 PROCESS_STATS_V1 Field Definitions
Description
Data Type
Field Name
Segment number of the process
INTEGER UNSIGNED NO
DEFAULT
SEGMENT_ID
Processing node number of the process
being measured
INTEGER UNSIGNED NO
DEFAULT
NODE_ID
Unique number.
INTEGER UNSIGNED NO
DEFAULT
PIN
ANSI SQL timestamp, in Local Civil
Time, indicating when the
measurement interval ended
TIMESTAMP(6)
MEASURE_END_DATETIME
ANSI SQL date, in Local Civil Time,
indicating when the measurement
interval ended
DATE
MEASURE_END_DATE
Process Statistics
75