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 following fields:

System ID	System ID
Object name	OLAP Statistik Object Name (QueryID, TemplateID,...)
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 parameters needs to be defined:

Parameter name	Description
DELAY_TO_CHECK_RSDDSTATS	Delay to check
JAVASTACK_COUNT_12503_X_MINUTES	Javastack count
JAVASTACK_MIN_12503_VARIANCE	Javastack 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 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 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 Statistik Object Name (QueryID, TemplateID,...)

BW Statistics: Number

Validity Period

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

KPI name	Description	Unit
BW_12503CNT	Javastack: count number of 12503
BW_12503CNT_NOTA	Javastack: count number of 12503 on not authorized node
BW_12503CXMN_AVG	Javastack: count number of 12503 Xminute-avg per node hourly
BW_12503CXMN_MAX	Javastack: count number of 12503 Xminute-maximum node hourly
BW_12503CXMN_MIN	Javastack: count number of 12503 Xminute-minimum node hourly
BW_12503CXMN_MNV	Javastack: count number of 12503 Xminute-variance min node
BW_12503CXMN_MXV	Javastack: count number of 12503 Xminute-variance max node
BW_12503HEAPMAX	Javastack : Max value of heap for all nodes
BW_12503MISSUSR	Javastack : No of users with 12502 without 12503 after x min
BW_12505NO	Javastack : No of queries rejected (stat 12505)
BW_12640NO	Javastack : No of javastack cache refresh (stat 12640)

NOTE: All standard javastack event KPIs have prefix BW_*

Browser not supported