(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

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

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

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