How to limit data retention for specific QOS objects

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

Some probes may have frequent intervals configured out of the box/by default, or you may simply need to save data more frequently for any given probe. Unfortunately, this may result in large tables over time if the data retention is long/high.

This particular example pertains to cdm IOSTAT QOS data but may also apply to data collected by cdm, snmpcollector or other probes.

Environment

Any supported UIM version 

Component : UIMDEG : UIM - DATA_ENGINE

Cause

- need to understand how to limit data retention for some QOS objects when frequency of collection causes a lot of data to be stored in the table(s).

Resolution

You can control how much raw and historical data is stored by adjusting the QOS using the data_engine GUI-> QOS “Quality of Service” Tab:

For example, for the QOS_IOSTAT_RS object, which in this case is iostat reads per second - you can override the default data_engine setting of saving raw data for 35 days and historical data for 180 days to 3 days and 5 days respectively, so the tables do not grow too large.

You can do this for any QOS object.

Double-click on the QOS object you want to change retention for and it opens a configuration window that lets you override the data retention settings:

Make the adjustment and click Ok.

The data_engine GUI will close and the retention settings will be saved.