Preface
Part 1: Introduction
Part 2: Configuring Hub Console Tools
- Configuring Access to Hub Console Tools
- Implementing Custom Buttons in Hub Console Tools
Part 3: Building the Data Model
Part 4: Configuring the Data Flow
Part 5: Executing Informatica MDM Hub Processes
- Using Batch Jobs
- User Exits
Part 6: Configuring Application Access
Appendix A: MDM Hub Properties
Appendix B: Viewing Configuration Details
Appendix C: Row-level Locking
Appendix D: MDM Hub Logging
Appendix E: Table Partitioning
- Support for Table Partitioning
Appendix F: Collecting MDM Environment Information with the Product Usage Toolkit
Appendix G: Informatica Platform Staging
Appendix H: Informatica Platform Mapping Examples
- Informatica Platform Mapping Examples Overview
- Generate Primary Keys Example
Appendix I: Glossary
- Glossary of Terms

Configuration Guide

10.4

Back Next

Periodically Purging the Audit Log

The audit log table can grow very large rapidly, particularly when capturing XML request and response information (when the Include XML option is enabled).

Using tools provided by your database management system, consider setting up a scheduled job that periodically deletes records matching a particular filter (such as entries created more than 60 minutes ago).

The following SQL statement shows an example for Oracle and IBM DB2:

DELETE FROM C_REPOS_AUDIT WHERE CREATE_DATE < (SYSDATE - 1) AND STATUS='INFO'

The following SQL statement shows an example for Microsoft SQL Server:

DELETE FROM C_REPOS_AUDIT WHERE CREATE_DATE < SYSDATETIME() AND STATUS='INFO';

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Periodically Purging the Audit Log

Periodically Purging the Audit Log