Viewing Change Data Capture policies for a table
You can view all the CDC policies defined for a table in the Change Data Capture Table Summary page.
To view CDC policies for a table:
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.
4. From the list, click the name of a table you want to view CDC policies for.
The Change Data Capture Summary page appears and displays the following information:
Policy Name — The name of the CDC policy.
Level — The level of data that is captured on the source table. The values are
Minimal (0),
Minimal with Bitmap (1),
Medium (2), and
Maximum (3).
State — The internal state of the policy—
Active or
Inactive.
Instance — The instance of the policy on the source table—
Current,
Pending, or
Previous.
Last Modified — The date and time the policy instance was last modified.
Description — The description of the policy.
Additionally, you can perform the following:
Use the
Search Policy field to search for a policy by its name.
Click
ADD CHANGE DATA CAPTURE POLICY to create a CDC policy for the selected table.
Click the name of a policy to view and edit its details.
Filter the list by policy name.
Delete one or more policies at once.
