Question & Answer
Question
I see the TAUD_ALO_AUDIT_LOG table is constantly being updated with different auditing information and events. How do I stop entries being added to the TAUD_ALO_AUDIT_LOG table?
Cause
The following types of audit information is saved to the TAUD_ALO_AUDIT_LOG table:
- Users who log on or log out of the application
- Items or roles that were created
- Item modifications
- Import and export activities
- Queries done using DB Admin
- Specs that were created
- Alerts that were created and are listed in the Alerts Subscription Console
Answer
Most actions done in the application involve an event. All event-related information is stored temporarily in the TEVT_QUE_QUEUE table. Events are added to an event queue. Audit logs are created every time an event is executed, then the event processor processes the event queue. Once the event queue has been processed and logged to the TAUD_ALO_AUDIT_LOG table, the event queue is emptied.
There are advantages and disadvantages of disabling audit logs and alerts:
- Advantage: If the application is used heavily the TAUD_ALO_AUDIT_LOG table may grow extensively which can lead to performance issues.
- Disadvantage: System events will not be logged and application alerts will not be received.
In order to stop events and alerts from being added to the TAUD_ALO_AUDIT_LOG table you have to set the parameter fire_event_processor_events = false in the $TOP/etc/default/common.properties.
Note: This change requires an application restart.
Product Synonym
WPC;WebSphere Product Center;MDM;MDMPIM;InfoSphere MDM Server for PIM;InfoSphere Master Data Management Server for Product Information Management
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21389960