The process is to identify the QOS you want to delete from the s_qos_data table
Using the table_id value, delete all records from the corresponding RN and HR tables with that table_id
Then delete the one row from s_qos_data with that table_id
Might want to do the same delete to s_qos_snapshot
Then bounce data_engine.
Generally speaking data_engine is the only thing that writes to these tables and it just adds values. Doesn't care what data is there already.
Obviously, test any queries and deletes first, make backups just in case, etc.
Original Message:
Sent: 11-18-2021 01:04 PM
From: Miller Grisepe Echagarreta Parra
Subject: Delete old qos from...
Hi everyone.
Does anyone know any method to delete old qos from the DB. In UIM 2033, doing it from SLM is a nightmare. In UIM 201 it was a bit more reliable, now the experience is not very comfortable.
In fact I tried to delete more than 1000 qos, but apparently it did not ... I'm giving it time to see if data_engine does the deletion, I just manually reboot the probe