(DI-2205) Collector for BW - Javastack events
- SNP
- Marian Vidra
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_*