Active IQ Unified Manager Discussions

Purge OCUM 7.2 Performance data 60 days

SrikanthReddy
5,908 Views

we upgraded OCUM to 7.2 and migrated perf data

is there a way to purge data older than a specified time manually like 60 days with database tables  ? 

 

8 REPLIES 8

marcusgross
5,584 Views

Hi,

 

no it isn't related.

 

It's the same problem here, we have 15 clusters in one OCUM. It's using 170g space now.

 

 

Marcus

marcusgross
5,514 Views

Hi,

 

it's not for OCUM 7.2.

 

Marcus 

ryan123
4,557 Views

did you ever get an answer for this question you asked ? or figured out how to do it .

 

my database drive is over 1tb now for events and history 

SrikanthReddy
4,523 Views

it did not look like possible without engaging custom netapp team ,

As we were moving to new Windows based server ,we migrated without history and start new install on new server 

 

marcusgross
4,446 Views

Hi,

 

I got this from the support, but the OCUM database is corrupt again. I can't delete some datasources.

 

Thats the hint from the support (not tested):

•	mysql> select * from opm.config where name like 'NUMBER_OF_DAYS_TO_RETAIN_DATA';
+----+-------------------------------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | name | value | description |
+----+-------------------------------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 3 | NUMBER_OF_DAYS_TO_RETAIN_DATA | 390 | This is how many days we keep OPM specific data (acquisitionInfo, forecasts, incidents and change events) in the database. Anything older than this value is deleted daily. |
+----+-------------------------------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec) 
o You can see here that the default value is 390 days. Setting this to something like 180 or 270 should be sufficient.
• mysql> update opm.config set value=270 where id=3; Query OK, 1 row affected (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 0
• mysql> select * from opm.config where name like 'NUMBER_OF_DAYS_TO_RETAIN_DATA'; +----+-------------------------------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | id | name | value | description | +----+-------------------------------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 3 | NUMBER_OF_DAYS_TO_RETAIN_DATA | 270 | This is how many days we keep OPM specific data (acquisitionInfo, forecasts, incidents and change events) in the database. Anything older than this value is deleted daily. | +----+-------------------------------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)

Marcus

Gage
4,288 Views

Hi, 

I am having the same issue with the datatbase growing I am at 250GB has anyone changed the datatbase retention to 60days?

Thanks

-Lyn

Public