Upgrade Guide › Upgrading Databases › Database Schema Changes

Database Schema Changes

If you are upgrading your CA DLP servers to r12.5, there are no major changes to the database schema but there are several minor changes.

For the current version of CA DLP, the database schema version is 3.60. This version includes the following changes to support the new database security models:

New tables and related indexes

Wgn3IssueTrigger

Wgn3Role

Wgn3ResourceType

Wgn3Resource

Wgn3ResourceRole

Wgn3UserRole

New table

TMP_WGN3POLICYRLS

Performance optimizations

Wgn3Trigger table

New index: IX_WGN3TRIGGER_POLICYID

Wgn3UserGroup table

New columns:

• EffectiveStartDate
• EffectiveEndDate

New Indexes:

• IX_WGN3USERDATEGROUP
• IX_WGN3GROUPDATEGUSER

TMP_WGN3ADDRRLS

(Oracle only) Removed indexes:

• IX_TMP_WGN3ADDRRLS_GROUP
• IX_TMP_WGN3ADDRRLS_USER

Note: Full schema details are available in the CA DLP Database Schema and Views Reference Guide.

More information:

Before Upgrading Your CMS: Run the ‘participant address’ Pre-Flight Check

Example Pre-Flight Check Output