(DI-2111) Collector for BW - Javastack events

The collector for BW - Javastack events is named: /DVD/MON_BW_CL_COL_JAVAST_EVT.

It collects KPIs about Javastack events. The KPIs are defined via KPI definition and input table /DVD/MON_BWJVNDD, which sets extended KPI definition with the following fields:

System ID

System ID

Object name

OLAP Statistics Object Name  (QueryID, TemplateID, etc.)

Do not check

Do not check

Do not run

Do not run

Comment

Comment

Change by user

Last change by user [automatically filled]

Change date

Last change date [automatically filled]

In collector following parameters need to be defined:

Parameter name

Description

DELAY_TO_CHECK_RSDDSTATSDelay to check
JAVASTACK_COUNT_12503_X_MINUTESJava stack count
JAVASTACK_MIN_12503_VARIANCEJava stack min

The collector provides also detailed output in detail tables for relevant KPIs. The first detail table is called BW Javastack No of 12503 per node - /DVD/MON_BWJVNOD with the following fields:

Client
Timestamp
System ID
Object Name 
Alerts count
Do not check
Do not run event 12503 on this node
Min value of Heap%
Max value of Heap%


The second detail table is called BW Failed query on Javastack - /DVD/MON_BWMISJV with the following fields:

Timestamp

System ID

BW Statistics: Day

BW Statistics Time

SESSIONUID

STEPUID

Internal ID of a Query Runtime Object

Internal Type of Query Runtime Object

OLAP Statistics Event

UTC time stamp in long-form

User Name

OLAP Statistics Object Name  (QueryID, TemplateID, etc.)

BW Statistics: Number

Validity Period


Some KPIs are provided in standard delivery with the collector as examples:

KPI name

Description

BW_12503CNT

Java stack: Count number of 12503

BW_12503CNT_NOTA

Java stack: Count number of 12503 on not authorized node

BW_12503CXMN_AVG

Java stack: Count number of 12503 Xminute-avg per node hourly

BW_12503CXMN_MAX

Java stack: Count number of 12503 Xminute-maximum node hourly

BW_12503CXMN_MIN

Java stack: Count number of 12503 Xminute-minimum node hourly

BW_12503CXMN_MNV

Java stack: Count number of 12503 Xminute-variance min node

BW_12503CXMN_MXV

Java stack: Count number of 12503 Xminute-variance max node

BW_12503HEAPMAX

Java stack: Max value of heap for all nodes

BW_12503MISSUSR

Java stack: No of users with 12502 without 12503 after x min

BW_12505NO

Java stack: No of queries rejected (stat 12505)

BW_12640NO

Java stack: No of Javastack cache refresh (stat 12640)

NOTE: All standard Javastack event KPIs have prefix BW_*