Collector for BW - Java Stack Events
The technical name of the Collector for BW – Java Stack Events is /DVD/MON_BW_CL_COL_JAVAST_EVT.
This collector collects KPIs about Java Stack events. The KPIs are specified via the KPI definition and the input table /DVD/MON_BWJVNDD.
The input table /DVD/MON_BWJVNDD sets the extended KPI definition. It contains the following fields:
|
System ID |
System ID |
|---|---|
|
Object name |
OLAP statistics object name (QueryID, TemplateID, etc.) |
|
Do not check |
Do not check (exclude) this object |
|
Do not run |
Do not run event 12503 on this object |
|
Comment |
Comment |
|
Changed by user |
Last changed by user [automatically filled] |
|
Change date |
Last change date [automatically filled] |
Parameters
The following parameters are used for this collector:
|
Parameter name |
Description |
|---|---|
|
DELAY_TO_CHECK_RSDDSTATS |
Delay before checking RSDDSTAT |
|
JAVASTACK_COUNT_12503_X_MINUTES |
Java Stack count |
|
JAVASTACK_MIN_12503_VARIANCE |
Java Stack minimum |
The collector also provides detailed information in the detail tables for relevant KPIs. The first detail table is called BW Java Stack no. of 12503 per node – /DVD/MON_BWJVNOD. It contains 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 Java Stack – /DVD/MON_BWMISJV. It contains the following fields:
|
Timestamp |
|---|
|
System ID |
|
BW statistics: Day |
|
BW statistics: Time |
|
SESSIONUID |
|
STEPUID |
|
Internal ID of query runtime object |
|
Internal type of query runtime object |
|
OLAP statistics event |
|
UTC time stamp in long form |
|
Username |
|
OLAP statistics object name (QueryID, TemplateID, etc.) |
|
BW statistics: Number |
|
Validity period |
Some KPIs are provided in the standard delivery with the collector as examples:
|
KPI name |
Description |
|---|---|
|
BW_12503CNT |
Java Stack: Number of OLAP stats with event 12503 |
|
BW_12503CNT_NOTA |
Java Stack: Number of 12503 events on non-authorized node |
|
BW_12503CXMN_AVG |
Java Stack: Average number of 12503 events per node |
|
BW_12503CXMN_MAX |
Java Stack: Maximum number of 12503 events per node |
|
BW_12503CXMN_MIN |
Java Stack: Minimum number of 12503 events per node |
|
BW_12503CXMN_MNV |
Java Stack: Minimum variance of 12503 events per node |
|
BW_12503CXMN_MXV |
Java Stack: Maximum variance of 12503 events per node |
|
BW_12503HEAPMAX |
Java Stack: Maximum amount of heap for all nodes |
|
BW_12503MISSUSR |
Java Stack: No. of users with 12502 and without 12503 after X mins |
|
BW_12505NO |
Java Stack: Number of rejected queries (event 12505) |
|
BW_12640NO |
Java Stack: Number of cache refreshes (event 12640) |
