UIM MCS SSRV2AuditTrail table is over 24gb in size.

book

Article ID: 106271

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Infrastructure Management

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.