Try OpenEdge Now
skip to main content
Managing Change Data Capture in Databases
Managing Change Data Capture in a Database : Activating and deactivating a current Change Data Capture policy
 

Activating and deactivating a current Change Data Capture policy

You can activate or deactivate a current Change Data Capture (CDC) policy based on its state—inactive or active—using the Change Data Capture Tables List page. In this page, you can also select current CDC policies in bulk and activate or deactivate them at once.
When activating or deactivating CDC policies, the following guidelines apply:
*You cannot activate or deactivate a pending or a previous policy.
*When activating current CDC policies, select only those policies whose state is Inactive as the Change Data Capture Tables List page lists both active and inactive policies.
*When deactivating current CDC policies, select only those policies whose state is Active as the Change Data Capture Tables List page lists both active and inactive policies.
To activate or deactivate a current CDC policy:
1. From the OpenEdge Management console menu, select Database Administration > Go to Database Administration.
The Database Administration page appears.
2. From the list of database connections, select a connection for which you want to activate or deactivate a current CDC policy.
The selected database connection home page appears.
3. In the Storage Management section, click Change Data Capture Tables List.
The Change Data Capture Tables List page appears.
4. To activate a current CDC policy:
a. From the list of CDC tables, select the table that has the current CDC policy that you want to activate.
When selecting a current CDC policy to activate, you must select a table that displays a CDC policy in the Current Policy column and Inactive in the Policy state column.
b. Click Activate, and then click YES in the confirmation dialog box.
The state of the selected current CDC policy changes to Active and appears in the Change Data Capture Tables List page.
5. To deactivate a current CDC policy:
a. From the list of CDC tables, select the table that has the current CDC policy that you want to deactivate.
When selecting a current CDC policy to deactivate, you must select a table that displays a CDC policy in the Current Policy column and Active in the Policy state column.
b. Click Deactivate, and then click YES in the confirmation dialog box.
The state of the selected current CDC policy changes to Inactive and appears in the Change Data Capture Tables List page.