Subscribe

Purge OCUM 7.2 Performance data 60 days

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

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

Cannot find the answer you need?  No need to open a support case - just CHAT and we’ll handle it for you.

Re: Purge OCUM 7.2 Performance data 60 days

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

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

Cannot find the answer you need?  No need to open a support case - just CHAT and we’ll handle it for you.

Re: Purge OCUM 7.2 Performance data 60 days

Hi,

 

it's not for OCUM 7.2.

 

Marcus 

Re: Purge OCUM 7.2 Performance data 60 days

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

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

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

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