Extremely high volume in CEM's SYSACCESS table

book

Article ID: 193682

calendar_today

Updated On:

Products

CA Compliance Event Manager

Issue/Introduction

The customer converted all stored procedure calls to SECURITY USER.  This caused a significant volume increase in ICH0007I messages, and at IBM's recommendation, applied PTFs UA82153 and UA82154 and updated the system configuration as par APAR OA50291 https://www.ibm.com/support/pages/apar/OA50291
However,  there was a significant increase in the information captured in CEM's database SYSACCESS table.  Is there an equivalent change to implement in CEM to prevent capturing this information?

 

Environment

Release : 6.0

Component : CA COMPLIANCE EVENT MANAGER

Resolution

CEM processes RACROUTE calls and not just the messages produced. The customer's policy will want to filter the attributes/parameters associated with RACROUTE for a particular event. The customer will add the appropriate exclusion rules, thus minimizing the volume written to the SYSACCESS tables.