topic Re: Purge OCUM 7.2 Performance data 60 days in Active IQ Unified Manager Discussions

Purge OCUM 7.2 Performance data 60 days

SrikanthReddy — Wed, 04 Jun 2025 14:49:53 GMT

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 ?

Re: Purge OCUM 7.2 Performance data 60 days

Jeff_Yao — Wed, 26 Jul 2017 10:02:28 GMT

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

Re: Purge OCUM 7.2 Performance data 60 days

marcusgross — Tue, 01 Aug 2017 08:54:44 GMT

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

Re: Purge OCUM 7.2 Performance data 60 days

Jeff_Yao — Tue, 01 Aug 2017 10:18:00 GMT

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

Re: Purge OCUM 7.2 Performance data 60 days

marcusgross — Wed, 02 Aug 2017 08:50:24 GMT

Hi,

it's not for OCUM 7.2.

Marcus

Re: Purge OCUM 7.2 Performance data 60 days

ryan123 — Tue, 03 Apr 2018 19:49:31 GMT

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

Re: Purge OCUM 7.2 Performance data 60 days

SrikanthReddy — Tue, 03 Apr 2018 21:04:27 GMT

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

Re: Purge OCUM 7.2 Performance data 60 days

marcusgross — Thu, 05 Apr 2018 08:03:34 GMT

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

Re: Purge OCUM 7.2 Performance data 60 days

Gage — Fri, 20 Apr 2018 17:20:54 GMT

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