(DI-2205) Collector for Number Ranges
The technical name of the Collector for Number Ranges is /DVD/MON_CL_COL_NUM_RANGE.
This collector runs once per day and monitors changes in number range across clients. Users can set up custom thresholds to change reporting as a difference (how many IDs were assigned from the number range) and speed (estimated number of IDs assigned per day).
When content for Input table /DVD/MON_NR is not defined, all number ranges are monitored by default, and thresholds (especially percentage thresholds) are pulled from table TNRO (Number Range Object Info). Some Number range records available in table TNRO might have reversed thresholds (for example, 99.9% value means that collector will report this particular Number range record into detail table as soon as 0.01% of numbers are used). This may confuse why is number range exceeds the percentage threshold and is reported in CrystalBridge Monitoring even in the case that 100% of it is free.
Default KPIs delivered with this collector
The following default KPIs are delivered with this collector:
KPI name | Description | Unit | Detail table |
---|---|---|---|
NR_OVER_THR | Count of number ranges that are over the threshold | Count | Yes |
NR_MAX_DIFF | Maximum from an incremental difference of all number ranges | Count | Yes |
NR_TOTAL_DIFF | Sum of all incremental differences from number ranges | Count | Yes |
NR_MAX_SPEED | Maximum from incremental speed* of number ranges | Val/d | Yes |
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 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.
Input table
Collector uses input table /DVD/MON_NR where user can specify what details will be extracted into detail table /DVD/MON_S_NR_INFO.
Wildcards are supported for detail table /DVD/MON_NR. Also, Input table thresholds override thresholds from collector's parameters.
OBJECT | Name of the number range object |
SUBOBJECT | Number range object subobject |
NRRANGENR | Number range number |
TOYEAR | TO fiscal year |
SPEED_THR | Speed threshold |
DIFF_THR | Difference threshold |
PERC_THR | Percentage threshold |
Parameters
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 |
PERCENTAGE_THRESHOLD | Number ranges that reach the percentage threshold will also be reported. For example, if NR has a range 1-100, is currently on 95 and you set the threshold for 10% number range will be reported. |
Detail table
The collector provides detailed table Number range info. The technical name of the detail table is /DVD/MON_S_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 |
NRLEVEL_DIFF | Last Number Range level difference |
NRLEVEL_SPEED | Incremental speed of Number Range |
NRLEVEL_PERC | Percentage threshold for this number range |
REASON | Which threshold was hit by number range (SPEED/DIFFERECE/PERCENTAGE) |
BUFFER_TYPE | Buffer type (X-main memory, L-Local memory, etc.) |
BUFFER_SIZE | Buffer size (No. of numbers that must be held in the buffer). |