Purge OCUM 7.2 Performance data 60 days

[SrikanthReddy]

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  ? 

[Jeff_Yao]

not sure if this is related?

https://kb.netapp.com/support/s/article/ka31A0000008h5uQAA/how-to-install-and-use-the-dfm-purge-tool?language=en_US

thanks

[marcusgross]

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

[Jeff_Yao]

how about this?

https://kb.netapp.com/support/s/article/ka31A00000013LJQAY/how-to-clean-up-the-oncommand-unified-manager-5-x-database?language=en_US

thanks

Jeff

[marcusgross]

Hi,

it's not for OCUM 7.2.

Marcus 

[ryan123]

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]

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]

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]

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