UIM MCS SSRV2AuditTrail table is over 24gb in size.

Article Id: 106271
Status: Published
Updated On: 01-07-2019 14:31
Products:
NIMSOFT PROBES CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
Issue/Introduction:



The UIM MCS SSRV2AuditTrail table is over 24gb in size. How can it be reduced in size. 

Environment:

Release:


Component:

Resolution:

The SSRV2AuditTrail history can be safely removed. 

This script will empty SSRV2AuditTrail and SSRV2AuditTrailModification.

USE <your database name>;
TRUNCATE TABLE SSRV2AuditTrailModification;
ALTER TABLE SSRV2AuditTrailModification DROP CONSTRAINT FK_SSRV2AuditTrailModification_SSRV2AuditTrail;
TRUNCATE TABLE SSRV2AuditTrail;
ALTER TABLE SSRV2AuditTrailModification WITH NOCHECK ADD  CONSTRAINT FK_SSRV2AuditTrailModification_SSRV2AuditTrail FOREIGN KEY(auditrecord)
REFERENCES SSRV2AuditTrail(id);
ALTER TABLE SSRV2AuditTrailModification NOCHECK CONSTRAINT FK_SSRV2AuditTrailModification_SSRV2AuditTrail;
 

Additional Information:

In mon_config_service-8.5.8-HF4 has added garbage collection of the MCS SSRV2Audittrail and SSRV2AudittrailModification tables.


It is available from here:

https://techdocs.broadcom.com/us/product-content/recommended-reading/technical-document-index/ca-unified-infrastructure-management-hotfix-index.html?r=2


Follow the deployment instructions details in the readme.