DX Unified Infrastructure Management

Hi All,

We are using CA UIM monitoring tool to monitor our client infra and application services for past 2+ years.

I want to delete the older QOS data from database which are of past 365 days which will help to reduce the database size growth.

Please let me know which table is associated with QOS data.

Thanks 

By default the data_engine should be managing old data based on the retention times that you have configured in this probe.  The following Knowledge Document explains how the data retention works in the data_engine:

KB000045990 : How does data_engine handle retention?

If you suspect that the data_engine is not performing maintenance, you can use the SQL query in the following Knowledge Document to determine which, if any tables, contain more data than the configured retention periods:

KB000034940 : Verifying that data_engine is deleting old raw and historic data properly from the database

If the outputs of the query indicate that there are tables that contain old data that should have been deleted, then you can use the data_engine probe maintenance to incrementally delete unwanted old data.  Instructions for this can be found in the following Knowledge Document:

KB000009547 : How to trouble shoot data retention and Database growth

Substitute the RN_QOS_DATA_NNNN tables reported in the output of the SQL query from KB000034940 for step 1 in KB000009547 to determine the age of the data in the tables that contain unwanted old data.

Hope this helps.