1827629 Members
3404 Online
109966 Solutions
New Discussion

Re: Is it possible to clean db?

 
SOLVED
Go to solution
dasi66
Frequent Advisor

Is it possible to clean db?

I would like to clean db. Is it possible? Running IMC 7.3, mysql and Linux RH 7.

 

perf_db is about 3 GB

config_db is 1 GB

 

All other db_ is virtually nothing.

1 REPLY 1
Nitish_N
HPE Pro
Solution

Re: Is it possible to clean db?

Hi,

Perf_db in iMC is used for performance monitoring of devices and its history and config_db on other hand is used for configuration backup of monitored device.

For Perf_db, there is no option to clean up the old data directly for GUI. deleting and re-adding the device will delete perf_db entry for the device but the process is no recommended if old data in sensitive for end customer. Then second we have is to try purging/shrinking database directly with the help of MySql admin. 

For Config_db, we have option from GUI to modify device backup configuration file lifespan. Navigate to Main tab Services > Configuration Centre > Option > Backup Policy > Max. Backup Configuration History Days and change the value as needed. By default, file will be stored for 180 days and post that it will be deleted. 

-N


Accept or Kudo