Try OpenEdge Now
skip to main content
Database Administration
Reference : PROUTIL Utility : PROUTIL ENABLECDC qualifier
 

PROUTIL ENABLECDC qualifier

Enables your database for Change Data Capture (CDC).

Syntax

proutil db-name -C enablecdc
area table-areaname indexarea index-areaname
[ deactivateidx ]

Parameters

db-name
The name of the database where you are enabling CDC.
areatable-areaname
The name of the area where your Change Tracking Table (_Cdc-Change-Tracking) will reside. The area must be a Type II area, and must be created prior to enabling CDC. Progress Software recommends that you create an area exclusively for the Change Tracking Table.
indexareaindex-areaname
The name of the area where the indexes of your Change Tracking Table will reside. The area must be a Type II area, and must be created prior to enabling CDC. Four indexes are created for the Change Tracking Table (_Change-Sequence (primary), _Part-Rec-Id, _Policy-Id, _Tran-Id). Progress Software recommends that you create an area exclusively for the Change Tracking Table indexes.
deactivateidx
Add deactivateidx to disable the non-primary indexes of the Change Tracking Table. If deactivated during this enablement, the indexes can be activated at a later time with one of the index utilities (IDXBUILD, IDXACTIVATE,IDXFIX).
Successful execution of ENABLECDC makes your database ready to create CDC policies for capturing change data.
See:
*PROUTIL DISABLECDC qualifier

Note

ENABLECDC is an auditable event, if your database is enabled and configured for auditing.