(DI-2302) Collector for BW Number Ranges
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 the 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.
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 | Count | Yes |
BW_NR_MAX_DIFF | Maximum from an incremental difference of all number ranges | Value | Yes |
BW_NR_TOTAL_DIFF | Sum of all incremental differences from number ranges | Value | Yes |
BW_NR_MAX_SPEED | Maximum from incremental speed* of number ranges | Val/d | Yes |
BW_NR_TOTAL_SPEE | Incremental speed from all number ranges | Val/d | Yes |
*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 starts it one hour later while some number range assigned five 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 BW: 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 | Time 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, sub object value |
NRRANGENR | Number range number |
TOYEAR | TO fiscal year |
EXTERNID | Internal (' ') or external ('X') number range flag |
NRLEVEL | Number range status |
IOKEYNR | Info Object 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 memory, etc.) |
BUFFER_SIZE | No. of numbers that must be held in the buffer |