(DI-1802) Collector for BW - Javastack events
- Veronika Hunorova (Unlicensed)
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_*