(DI-2111) Collector for BW Number Ranges

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

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

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 Insights 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

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