DX NetOps

Hi,

I am seeing ibd files created on my one click server. There are quite a few of these files which add up to 70 GB of data. Can someone provide some insight on these files and what they are used for. Is there an archive or purge process for these files?

event#p#event_p63.ibd

D:\app-spec\mysql\data\reporting

Thanks,

Arnab

*.ibd files in OneClick server are related to reporting database. The Archiving or Purging of the reporting DB data is based on the setting at --> OneClick Webpage --> Administration --> Report Manager --> Preferences.

Below KB article describes the settings of data retention policy.

Spectrum Report Manager Data Retention Policy and Data Retention Period usage 

Use the below link to understand Spectrum Report Manager Database Schema and related information.

https://communities.ca.com/docs/DOC-97445480#jive_content_id_How_to_optimize_the_Report_Manager_Database 

Hope this helps.

Regards,

Rajashekar

I am moving this thread to the spectrum community please be sure to follow that space: CA Spectrum 

Hi Arnab,

Did the reply from Rajashekar help?

Yes it did help. Thanks for the information.