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_RSDDSTATS	Delay to check
JAVASTACK_COUNT_12503_X_MINUTES	Java stack count
JAVASTACK_MIN_12503_VARIANCE	Java 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_*

Browser not supported