Hello,
usm_system_change_detail is one of the big table in size, and its alomost 64GB as of now. Could you please let me know why is this table so large and can we archie and purge this and can we do it with Purge rule?
Regards
sharath
sharamateti
You can leverage the following to optimize and archive/purge the usm_system_change_detail table:
1) Optimize the System Change Detail Tables
https://docops.ca.com/ca-service-management/14-1/en/implementing/implementing-ca-service-management-14-1/step-4-install-or-upgrade/implementing-ca-service-catalog/how-to-upgrade-ca-service-catalog/step-1-plan-your-ca-service-catalog-upgrade#Step1-PlanyourCAServiceCatalogUpgrade-OptimizetheSystemChangeDetailTables
2) Archive and Purge Historical Data using 'Audit' object type:
https://docops.ca.com/ca-service-management/14-1/en/administering/administering-ca-service-catalog/archive-and-purge-historical-data