Database Guide › Database Storage and Partitioning › Overview › Which Tables Are Partitioned and Purged?

Which Tables Are Partitioned and Purged?

The default partitioning and purging scheme supported by CA DLP creates partitions in the primary event table plus all related tables in the CMS database. These tables are all partitioned by event timestamp using exactly the same partition boundaries. Partition-based purges affect the same tables. :

The tables affected by partitioning and purging are:

• Wgn3Event
• Wgn3EA
• Wgn3EventAudit
• Wgn3EventIssue
• Wgn3EventIssueParticipant
• Wgn3EventParticipant
• Wgn3IssueTrigger
• Wgn3Trigger
• Wgn3Transaction
• WgnUEexport

In some tables, the volume of accumulated data may not be large enough to warrant a purge operation, but the specified partition is purged anyway to maintain consistency with other partitioned tables.