MCS SSRv2Audit Trail table is using up a lot of space

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)
• Unified Infrastructure Management for Mainframe

Issue/Introduction

The SSRV2AuditTrail table is growing at a fast rate, approx. 100k rows per hour and it uses up a lot of disk space. If its safe to disable this auditing, please explain how.

Environment

Release : 20.3 or higher

Component: UIMMCS

mon_config_service probe v20.3 or higher

Cause

- fast growth of SSRV2AuditTrail table

Resolution

1. Via Raw Configure, add this parameter/key (if it doesn't exist) in the mon_config_service probe and set it to false.

     audit_enabled = false

2. Then run this SQL statement.

BEGIN TRANSACTION;

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;

COMMIT;

 

3. Cold start the mon_config_service probe (Deactivate-Activate)

    The SSRV2AuditTrail table should no longer build up in size.

4. To recheck the table row count, run:

     select count(*) from SSRV2AuditTrail

     ...and you should see no further rows being added to the SSRV2AuditTrail table.