AnsweredAssumed Answered

UIM Database is growing rapidly

Question asked by Rajashekar Allala on Feb 7, 2017
Latest reply on Feb 9, 2017 by Rajashekar Allala

Hi All,

 

We are observing that, the UIM database is growing rapidly and the disk space on the server is almost full. We have increased the disk space several times in last 6 months and unable to predict the future data growth.

 

Below are the DB maintenance settings on data_engine probe.

 

When I run the below query, I see the Daily Average Age value is 744. Is this the one causing the DB growth?

Data Retention

 

How can I change the setting for Daily Average Age (DAILYAVGAGE) to a value lower than 744? Please let me know.

 

Also, below are the tables do not have data in them. Can we suspect any issue with UIM database? Please clarify me.

 

RN_QOS_DATA_0001
RN_QOS_DATA_0002
RN_QOS_DATA_0003
RN_QOS_DATA_0004
RN_QOS_DATA_0005
RN_QOS_DATA_0006
RN_QOS_DATA_0010
RN_QOS_DATA_0014
RN_QOS_DATA_0015
RN_QOS_DATA_0016
RN_QOS_DATA_0020
RN_QOS_DATA_0027
RN_QOS_DATA_0036
RN_QOS_DATA_0038
RN_QOS_DATA_0039
RN_QOS_DATA_0040
RN_QOS_DATA_0041
RN_QOS_DATA_0042
RN_QOS_DATA_0046
RN_QOS_DATA_0047
RN_QOS_DATA_0048
RN_QOS_DATA_0049
RN_QOS_DATA_0050
RN_QOS_DATA_0051
RN_QOS_DATA_0053
RN_QOS_DATA_0062
RN_QOS_DATA_0080
RN_QOS_DATA_0087
RN_QOS_DATA_0091
RN_QOS_DATA_0094
RN_QOS_DATA_0096
RN_QOS_DATA_0098
RN_QOS_DATA_0100
RN_QOS_DATA_0104
RN_QOS_DATA_0105
RN_QOS_DATA_0109
RN_QOS_DATA_0110
RN_QOS_DATA_0111
RN_QOS_DATA_0112
RN_QOS_DATA_0113
RN_QOS_DATA_0114
RN_QOS_DATA_0116
RN_QOS_DATA_0117
RN_QOS_DATA_0118

 

 

 

Regards,

Rajashekar

Outcomes