After experiencing a large volume of alarms, we had to manually trim some database tables in MySQL. I would like to find more information about the following tables to decide what to do with them:
- Rep_pd_states = 109M entries
- Rep_pd_newalarms = 16M entries
The Help only indicates they are associated to the alarms.
Could someone explain what these tables are used for and what could be the impact of removing some/all entries.
Thanks.
Hi Miguel,
Both rep_pd_states and rep_pd_newalarms are tables primarily used by the SLASPConnection in DataMiner to generate reports. They serve a purpose similar to what the timetrace does in cassandra.
The rep_pd_states contains data regarding the states an element/parameter was in over time. This is used in heatmaps and timelines in reports.
The Rep_pd_NewAlarms keeps track what the first severity was each time a monitored parameter went into alarm. This is used for reports like "new alarm types" .
Deleting these tables will not hurt the system, however keep in mind that SLASPConnection will regenerate them when it is needed for a report.
Not just in Reporter, but also the timelines shown in Cube are using this data.