DB02 HDB Alerts - Location of data

[Former Member]

In HDB SAP Systems via. Transaction DB02 -> Current Status -> Alerts the current alerts are displayed in the window on the right side

Question: From where this data is read / calculated so that in can be retrieved in own programs. I thought the view M_MERGED_TRACES could be the solution, but I could not find the same date there. All hints are appreciated: Name of view, function module, coding in DB02, method / class, ...

Thank you for Support.

[Former Member · Accepted solution]

These alerts are collected by the SAP HANA statistics server. You can check SAP Note 2147247 for details. The data is stored within tables of the _SYS_STATISTICS schema. Some SQL statements from SAP Note 1969700 (starting with "HANA_StatisticsServer") can provide you with ideas where you can find details.