Try OpenEdge Now
skip to main content
Managing Change Data Capture in Databases
Managing Change Data Capture in a Database : Viewing Change Data Capture tables
 

Viewing Change Data Capture tables

You can view a list of tables that are CDC enabled in the Change Data Capture Tables List page. The list displays all the tables that have any CDC policies defined, irrespective of the policy instance being current, pending, or previous, and the policy state being active or inactive.
To view CDC enabled tables:
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 the required connection.
The 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 and displays the following information:
*Owner — The owner of source table, PUB or non-PUB.
*Table name — The name of the source table.
*Change Table — The name of the change table.
*Current Policy
*Policy name — The name of the current policy for the source table.
*Policy state — The state of the current policy—active or inactive—for the source table.
*Pending policy — The pending policy for the source table.
*Previous policy (Count) — The number of previous policies for the source table.
In addition, you can perform the following:
*Use the Search Policy/Table field to search for a policy or table by its name.
*Click ADD CDC POLICY to create a CDC policy.
*Click the name of a table to view a list of CDC policies for that table in the Change Data Capture Table Summary page.
*Click the name of the CDC policy in the Pending policy column to edit that policy.
*Hover over the information icon of a current or pending policy to view its state, level, and description.
*Filter the list by table name, policy name, or policy state.
*Activate or deactivate one or more current policies at once.