(DI-2211) Collector for BW Number Ranges
- SNP
This collector runs once per day and monitors changes in number range across clients. Users can set up custom thresholds for change reporting as a difference (how many IDs were assigned from the number range) and speed (estimated number of IDs assigned per day).
Default KPIs delivered with collector
The technical name of the Collector for Table size statistics is /DVD/MON_BW_CL_COL_NUM_RANGE
This collector runs once per day and monitors changes in number range across clients. Users can set up custom thresholds for change reporting as a difference (how many IDs were assigned from the number range) and speed (estimated number of IDs assigned per day). By default, it monitors all number ranges that were changed in the last 24 hours.
The default KPIs for total table and index sizes have assigned a Detail table that contains further details for each table.
Default KPIs delivered with this collector
The following default KPIs are delivered with this collector:
KPI name | Description | Unit | Detail table |
|---|---|---|---|
BW_NR_OVER_THR | Count of number ranges that are over the threshold | Number | No |
BW_NR_MAX_DIFF | Maximum from an incremental difference of all number ranges | Number | No |
BW_NR_TOTAL_DIFF | Sum of all incremental differences from number ranges | Number | No |
BW_NR_MAX_SPEED | Maximum from incremental speed* of number ranges | Number | No |
BW_NR_TOTAL_SPEE | Incremental speed from all number ranges | Number | No |
*Speed - this value represents how many IDs are assigned by number range per day. The collector is supposed to run once per day by default, but when the user manually stops the collector, and start it one hour later while some number range assigned 5 IDs, the collector will assume that per 24h, it will be 120 IDs, so this metric is more of an estimation.
Parameters
The following parameters are used for this collector:
Parameter name | Description |
|---|---|
DIFFERENCE_THRESHOLD | The only number ranges that assigned more IDs than this value will be monitored and reported into the CrystalBridge® Monitoring and detail table |
SPEED_THRESHOLD | Only number ranges that assign IDs per day faster than this value will be monitored |
Detail table
The collector provides detailed table Number range info. The technical name of the detail table is /DVD/MON_NR_INFO
Number range info reports all number ranges that changed since the last run of the collector
Technical name | Description |
|---|---|
TIMESTAMP | When the records are saved into the Detail table |
SID | System ID |
CLIENT | Client ID |
OBJECT | Name of the number range object |
SUBOBJECT | Number range object subobject |
NRRANGENR | Number range number |
TOYEAR | TO fiscal year |
EXTERNID | Internal (' ') or external ('X') number range flag |
NRLEVEL | Number range status |
IOKEYNR | InfoObject key using Number Range (Characteristic, dimension) |
NRLEVEL_DIFF | Last Number Range level difference |
NRLEVEL_SPEED | Incremental speed of Number Range |
BUFFER_TYPE | Buffer type (X-main memory, L-Local memor, etc.) |
BUFFER_SIZE | No. of numbers that must be held in the buffer |