(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

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

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

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).