When editing CDC policies, the following guidelines apply:
  • At any given point of time, a CDC table can have no more than one pending policy and one current policy; however, it can have any number of previous policies.
  • If a current policy already exists for a CDC table, and you change the state of a pending policy to Active to make it a current policy, the existing current policy becomes a previous policy.
  • You can change only the Description and State fields of a current policy whose state is active. However, you can also change the Level of a current policy whose state is inactive.

    To pause capturing the changes to the change table, set the state of the current policy to Inactive. To resume capturing the changes, you must set it back to Active.

  • You cannot edit a previous policy.
  • You cannot edit the Policy name, Database connection, and Table fields of a pending policy.

To edit a pending 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 edit a 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. From the list of CDC tables, click the name of the table for which you want to edit a CDC policy.
    The Change Data Capture Table Summary page appears with a list of CDC policies created for the table.
  5. From the list, click the name of the pending policy you want to edit.
    The Edit Change Data Capture policy page appears. In this page, you can:
    • Edit the Description of the policy.
    • Change the Level and State of the policy.
      Note: You can change the level of a pending policy but you cannot change the level of a current policy whose state is active. However, you can change the level of a current policy whose state is inactive.
    • Select or clear the Identifying fields check box. For more information about CDC fields and Identifying fields, see Selecting Change Data Capture fields.
    • Select or clear the CDC fields in the Select Change Data Capture Fields section.
  6. Click SUBMIT.
    The Change Data Capture Table Summary page appears with the changes made to the policy.
When editing a newly created current or pending policy for a source table that has an existing current policy and a change table, note that the change table of the existing current policy will be the change table for the new policy, and the existing current policy information is copied to the new policy. You can perform the following for a newly created policy:
  • Edit the Description field.
  • Change the Level and State for the new policy.

    If the level of the existing current policy is Minimal (0), the level of the new policy will be Minimal (0) and it cannot be changed to other levels. If the level of the existing current policy is greater than Minimal (0), you can change the level of the new policy to any of the following levels: Minimal with BitMap (1), Medium (2), or Maximum (3).

  • Add CDC field policies to the new policy whose level is greater than Minimal (0), but you cannot edit the existing CDC fields.